Transaction Review Reports

This report will show you all transactions without payees.

You can add payees to them individually or bulk-add.

You can also create vendors here.

The Expense Inconsistency Report shows you expense transactions in the current closing period that might be miscoded.

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 Button (the arrow in the circle to the left of the transaction).

Finally, you can fine-tune this 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.

Click below to try an interactive demo of the Expense Inconsistency report!

Screenshot overview

Video overview

The Uncategorized Transactions report is where you can see 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 in this Report (Ask My Accountant, Uncategorized Expense, etc.)

Watch the video below that shows how to add these accounts:

From here, you can ask any questions that you need to your Client Portal.

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.

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.

This report is only available if you enable Class or Location in File Settings.

See also: How do I turn on Class, Location, or Customers for a client file?

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.

This report is only available if you enable Customers/Projects in File Settings.

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.

See also: How do I turn on Class, Location, or Customers for a client file?

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 the current period, 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).

This report returns any bills or expenses that do not have attachments.

If you manage receipts for your clients, it's a great way to stay on top of anything you need to ask them for.

This report allows you to see all your 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 rules are functioning properly, so you can build the confidence to enable auto-add more broadly and automate more of your coding work.

This report is only available to Canadian QuickBooks 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.

You can also create your own custom reports for transactions that meet your own custom criteria in Keeper. To do so:

Custom reports can be particularly helpful if you want to track transactions in a certain class (e.g., a "suspense" class).

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