Report Basics
Here are a few basic notes on how report tables work in Keeper.
Transaction Status
When you're working on a report, you can mark a transaction as Reviewed by clicking the 👍 button. Doing this will hide that transaction in the report you're working on, but the same transaction may still appear in other reports.
For example, marking this Zoom transaction as reviewed will hide it in the Expense Inconsistency report. However, if it's missing a receipt, it will still show up as open in the Expenses and Bills without Attachments report, unless you separately mark it as Reviewed there too.
Transaction Status vs. Question Status
Separate from Transaction Status, questions about transactions can also have one of three statuses:
- Waiting on Client - you asked a question, and you're waiting on an answer.
- Responded - the client has answered your question, but it's still open, pending your action.
- Resolved - the question requires no further action from you or your client.
Transaction Status and Question Status are independent, so you can mark a transaction as reviewed without closing out your question.
Note: this is a new change as of August 18, 2022. Prior to that date, Transaction Status was global, so closing a transaction anywhere closed it from all reports and hid it in the Client Portal.
If you closed any transactions that had related transaction questions, those questions are now marked Resolved. That is to say, they won't re-appear for clients, so there's no additional action you need to take.
The More Information Button
The more information button is one of the most useful ways of finding out more about a transaction.
If you click the arrow in the circle to the left of a transaction, it opens the Transaction Detail Pane, which contains the following breakouts:
- Similar Historical Transactions – transactions with the same payee or description, as well as statistics on how transactions like that have been coded in the past.
- Transaction Line Items – line items on this transaction, if any.
- Attachments – attachments uploaded to Keeper or QuickBooks, if any.
You can also use this to exclude transactions from reports, or to transfer transactions between QuickBooks files (see: Inter-Company Transfers).
Report Exclusion Lists
Exclusion lists are a way of fine-tuning what shows up in a given report. These let you exclude transactions from reports based on their vendor, description, transaction type, or account.
For example, if your payroll provider keeps showing up in the Expense Inconsistency Report, you can exclude all transactions with that payee from showing up via the Exclusion List.
Exclusion list settings are per-report and persist across closes. For example, if you exclude the account "Owner's Draw" in the Transactions coded to Parent Accounts task, this exclusion will apply to all present, past, and future closes for this client only, and only for the Transactions Coded to Parent Accounts report.
You can edit a report's exclusion list by clicking the Edit Excluded List button in the top right-hand corner of the report.
Adding and removing reports
If there are certain reports that you don't want to run as part of your closing process, you can delete them by clicking Edit and then clicking Remove.
If you want to add these reports back later, or you want to add other, new reports, you can do so by clicking the Add New button below a section and selecting a report.
Date ranges
Any report can be run over the following date options:
- All Dates – all transactions in the current + last 12 months of a client's file.
- Past Month – all transactions in the month that you are reviewing.
- Past 12 months – all transactions in the last 12 months of a client's file
- Year to date – all transactions in the current year
- Quarter to date – all transactions in the current quarter (e.g., if you are in the June close, this will show transactions in April, May, and June).
- Current Month – transactions in the current month (e.g., if you are in the June close, this will show transactions in the month of July).
