Modules»Accounts Receivable»Balancing A/R $ Received with …
  • RSS Feed

Last modified on 12/23/2015 2:09 PM by User.

Balancing A/R $ Received with A/P Check Account

If you are using Accounts Payable Task #20 Check Account to reconcile to the bank statement, make sure it equals to the A/R dollar total received in Cash History (Task 20 in A/R). 

Anything posted in Cash/Receipts Entry & Editing (Task 2 in A/R) the “Total Amount Received” MUST always equal the amount deposited into the bank. 

  • When posting the Invoiced Order Holding File (Task 2 in O/E), if the orders have cash, checks and credit cards to them, those payments will be posted to Cash/Receipts Entry & Editing (Task 2 in A/R).  This task must be posted also.  Before posting, print an edit list to make sure the “Total Amount Received” is equal to the cash, checks, and credit cards deposited into the bank.
  • After entering the checks that were received in the mail into Cash/Receipts Entry & Editing (Task 2 in A/R) print an edit list before posting.  Make sure the “Total Amount Received” is equal to the amount deposited into the bank.
  • NOTE: We suggest that you post the checks that are received in the mail separately from the checks/cash/credit cards received and applied through the Order Processing module.

‚ÄčEvery day the deposits made in A/R are to be entered into the Check Account (Task 20 in A/P).  To ease reconciling with the bank, on a typical day you might have 3 or 4 entries’….one for the checks received in the mail, one for the checks/cash received and applied in the Order Processing module, and one or two for the credit card totals (some banks report VISA/MC and Discover as separate deposits).

Every day print to screen the Cash/Receipts History report (Task 20 in A/R).  Use Subtask #4:  Print Selected History Records, changing field #5 to PRE (print preview), 

  • Please enter – starting batch number:     ALL
  • Please enter – starting G/L account number:      ALL
  • Please enter – starting transaction type: ALL
  • Print report by:                                    2). Customer number/document date/division number
  • Please enter – starting customer number:           ALL
  • Please enter – starting document date:   06/12/xx  (as an example)
  • ending document date:                          06/12/xx  (as an example)0.
  • Please enter – starting division number: ALL
  • Suppress detail records? (YES/NO):                YES
  • When the report appears on the screen, enter an L for LAST screen.  Notate the “Total Cash Received”.  Then back out to the main menu.

Every day print to screen the Check Account report (Task 20 in A/P module).  Use Sub-task 4: Print Selected Checks Records, changing field # 5 to PRE (print preview), 

  • Please enter – starting TRX#: ALL
  • starting date:                             06/12/xx (as an example)
  • ending date:                              06/12/xx (as an example)
  • division #:                                 ALL

When the report appears on the screen, enter an L for LAST screen.  The “DEPOSITED” amount MUST be the same as the amount notated from the last page A/R Cash/Receipts History report from Step #3.