Transaction Review Reports
Updated over a week ago

Transactions without Payees

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.


Expense Inconsistency

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

(Right-click to enlarge)

Video overview


Uncategorized Transactions

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.


Transactions Coded to Parent Accounts

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.


Transactions > $X

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.


Transactions without Class or Location

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.


Expenses without a Customer

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.


Class Inconsistency

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).


Expenses and Bills without Attachments

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.


Transactions Auto-Added by Bank Rule

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.


Tax Inconsistency

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.

Saved Search Reports

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

  1. Click Add New at the bottom of the Transaction Review section

  2. Click + Add Report

    1. Click Add New Report

  3. Define the criteria for your Saved Search

(Right-click to enlarge)

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

(Right-click to enlarge)

Heads up!

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.

(Right-click to enlarge)

Did this answer your question?