Preparing a monthly AR roll-forward schedule

Produce a schedule to provide to auditors. It should include this information:

  • Beginning AR balance
  • Adjustments and invoices paid during the period
  • Module that produce the transactions that impact accounts receivable
  1. Ensure that the GL Account Setup record for the AR control account is set to summary.
    1. Select General Ledger > Setup > Account.
    2. Open the record for the AR control account .
    3. Click Edit.
    4. Select Summary in the Print Type field.
    5. Click Save.
  2. Run the GL Transaction Activity Report for the month to a file.
    1. Select General Ledger > Reports > GL Reports > GL Transaction Activity Report.
    2. Run a new or stored report.
    3. Specify File in the Print Type field, specify a file name, and then click Next.
    4. Specify ranges for the AR control account, and then click Next.
    5. Accept the default options, and click Next.
    6. Click Save to generate the report.
  3. Open the GL Transaction Activity Report file in an Excel spreadsheet and create a spreadsheet with these columns:
    • Post date
    • Period
    • Journal number
    • Module
    • Reference
    • Debit
    • Credit
    • Balance
  4. Use this information to determine your roll-forward schedule.
    Function Description Debit transaction Credit transaction
    Sales Entry Invoice Processing Report Invoice processing New invoices added to AR New credits memos added to AR
    Sales Order Entry Receive cash on account   New unapplied cash
    Customer Cash Receipt Entry Cash application Credit memos applied Invoice paid
    Customer Entry Roll Balances Report Service charges New service charges added to AR  
    Customer Transaction Entry AR transaction entry Miscellaneous adjustments Miscellaneous adjustments
    GL Transaction Entry and GL Entry Batch Update Report GL transaction entry Miscellaneous adjustments Miscellaneous adjustments