Setup a Custom Reconciliation Report
Use the following instructions to create a customized reconciliation report so that you can monitor the activity in your clearing accounts with better understanding.
In QuickBooks, go to the Reports Menu, and choose Custom Transaction Detail Report.
In the Modify Report window that opens, the Columns that should have a checkmark are: (left margin), Type, Date, Num, Name, Memo, Split, Debit, Credit, Balance. All other columns should be unchecked.
In this same window, choose to Total By: Class (choose from the pull-down list)
In the same Modify Report window, click on the Filters tab.
Then, in the Choose Filter area, choose the account you are using for Revenue Clearing. (You can check what account this is by looking in the Disbursement & JIB Manager Integrated Edition at the Preferences screen. The account will be listed in the Revenue Clearing Account field.)
Click OK to close out of the Modify Report window. The customized report you just created will now show on the screen.
Click on the Memorize button in the upper left corner of this report window. Name the report Revenue Clearing Reconciliation and click OK. This report will now be available to you from your Reports menu > Memorized Reports listing.
(Follow the same steps above for creating an Expense Clearing Reconciliation report based on your Expense Clearing account)
© SherWare, Inc., 2023 • Updated: 08/23/13
Comment or report problem with topic