Reconciliation Report
This snapshot report allows you to view Accounts Receivable cash for a specific period. To use this report, navigate to Reports > All Reports – Finance, or use the global search bar. If this is a report that you plan to use frequently, mark it as a favorite and add it to your Quick Links.
To access the report, you need the User Permission ‘Reconciliation Report’.
To generate this report, you just need to enter a Period Date Range. The date range will default to the next month, but can be changed as needed. The search will generate a table which shows the transaction type and the Cash, Barter and Void amounts. The data is displayed based on transaction type. There will be records for various invoice types (regular, master, etc.), as well as deleted line items, and payments. Each column in the table will reflect different information about your transactions.
There are columns for ‘In Period’ and columns for data ‘Ex Period’. In period means the action was performed within the set Invoice Due Date, whereas Ex Period means the item was done outside of the Invoice Due Date. For example, if you had an invoice worth $1,000 due in February that wasn’t paid until March, you would see $1,000 show up under the Cash Paid Ex Period column.
Updated 9/24/2025