The Transaction Review closing task section allows bookkeepers to review transactions that need attention, avoiding unexpected issues during the month-end close.

This report will show all transactions without payees.

Within the Expense Inconsistency report, Double automatically highlights transactions that may be miscoded by comparing current expenses against historical data. When your team makes corrections within this report, the changes are immediately synced to QuickBooks Online and Xero.

This report looks at each expense in the current period, cross-references those against transactions in the past year, and flags potential anomalies. You can find more about why transactions appear here by clicking the More Information arrow to the left of the transaction.

Toggle between Payee and Description within the Expense Inconsistency report in order to see inconsistencies with either!

Fine-tune the Expense Inconsistency report by clicking the Exclude button to exclude transactions that aren't actually inconsistent, or by switching to year-to-date filtering in settings if you've closed the books for the prior year.

The Uncategorized Transactions report shows any transactions that you need to ask your clients about.

To make sure you see those transactions, add/update the accounts that you code unknown transactions to (i.e. Ask My Accountant, Uncategorized Expense, etc.)

From here, send questions to the portal so that your clients can weigh in on uncategorized transactions.

This report shows you all transactions coded to parent accounts.

For example, if you have an Advertising account, and then a child account Advertising: Social Media, then any transactions coded to Advertising will show up here.

This report will show any transactions that exceed a certain dollar amount.

The default threshold is $1,000, but you can change this by clicking Edit Dollar Threshold. That change will save to this client for all future closes.

Edit $ thresholds for all clients under Practice Settings.

These reports will show any transactions that have not been assigned to a class or location.

To make the best use of this report, we recommend using the Exclusion List to filter out transaction types like transfers, payments, and bill payments that naturally do not have Class/Location.

The reports are only available if you enable Class/Location in your Client Settings 👇

This report will show any expense that does not have an assigned customer or project. This is useful if you use customer or project tracking on expenses.

You can also use an Inclusion List in this report to select only certain accounts to run this report against. For example, if you only apply customers to certain COGS accounts, you can choose those in the Inclusion List.

The report is only available if you enable Customers in your Client Settings 👇

The Class Inconsistency report works just like the Expense Inconsistency Report, except it checks for inconsistencies in classes, not accounts/vendors.

This report looks at transactions coded to different classes in the current period, then cross-references those against transactions in the past 12 months and flags potential anomalies.

You can find more about why transactions appear here by clicking the More Information Button (the arrow in the circle to the left of the transaction).

The Expenses and Bills without Attachments report shows just that - any bills or expenses that do not have attachments! If you manage receipts for your clients, this report is a great way to stay on top of anything you need to ask them for.

The Transactions Auto-Added by Bank Rule report shows all transactions that were auto-added by a bank feed rule as part of your month-end review.

We built this report to help you make sure your QuickBooks Online rules are functioning properly, allowing you to build the confidence to utilize "auto-add" more broadly and automate more of your coding work.

Double view 👇

QuickBooks Online view 👇

Create your own custom reports for transactions that meet your own custom criteria in Double.

Oftentimes, you'll want to choose the "Account or Split" criteria rather than just "Account" / "Split" to make sure your report pulls in all applicable transactions.

The Tax Inconsistency report is only available to Canadian QuickBooks Online files. It will show whether or not GST is consistently applied to transactions with particular vendors.

In the example below, Breakfast Table is flagged as inconsistent because sometimes it has GST applied but other times it does not.