Amounts shown on the receivable reconciliation report
There are several supporting accounts receivable documents that you can view to ensure that the amounts displayed on the receivable reconciliation report are correct.
Add:
The following items are added to the Balance, beginning of period amount (opening receivable balance).
WIP billings during period (including taxes)
Use the Invoice Journal Detail document to determine the total amount of invoices from WIP including taxes. To exclude interest and miscellaneous invoices from the report, access the document properties and in the
Filter field click the button to open the Equation Editor.
Select the following:
Field=Source
Comparison="is equal to"
Value=W
Click Validate to verify the equation and then click OK twice to close the Equation Editor and the Document Properties dialogs.
Miscellaneous billings during period
The Miscellaneous billings amount includes both miscellaneous invoices and interest invoices. Use the Invoice Journal Detail document to determine the total amount of miscellaneous invoices. To exclude WIP invoices from the report, access the document properties and in the
Filter field click the button to open the Equation Editor.
Select the following:
Table=Receivables
Field=Source
Comparison="is not equal to"
Value=W
Click Validate to verify the equation and then click OK twice to close the Equation Editor and the Document Properties dialogs.
Less:
The following items are subtracted from the Balance, end of period amount (closing receivable balance).
Cash receipts during period
This amount matches the Total amount in the Cash Receipts Journal – Client – Number, which includes only those items posted to the Accounts Receivable general ledger account number. This amount does not include sundry payments (e.g., rent). You can also use the Cash receipt journal – summary report, which shows the total amount posted to Accounts Receivable General Ledger account.
Credit notes during period
This amount matches the Total amount in the Debit or Credit columns of the Credit Note Journal – Summary.
Notes
- To build filter calculations easily, use the Equation Editor. Click to access it.