Keeper Docs

⌘K
Keeper Docs Overview
🏁Getting Started
What is Keeper
Getting Started Guide
Security at Keeper
✅Task Management
Client List
Task Inbox
Task Types
Templates Overview
Copying Tasks
Non-QBO Clients
Permissions and Access Controls
Locking Tasks
In-App Chat (Collaboration)
Quarterly Clients
Close Assignees (Preparer / Reviewer)
Close Statuses
Priority Tasks
Gmail Integration
Workflow Management Notifications
💬Client Portal
Overview
Asking Questions
What your client sees
Communicating with your client
🔎File Reviews
Report Basics
Bulk Editing
Transaction Review Reports
Entity Review Reports
Final Review (Financial Statements)
Inter-Company Transfers
Transaction Splitting
Search All Transactions
Canadian Sales Tax (GST / HST)
Prepare 1099s
📈KPIs and Management Reports
Management Reports
The Executive Summary
Custom Columns
Report Templates
Metrics
Locking Reports
🗄️Client Management
Client Properties
Client Details
Client Notes
Files
⏲️Time Tracking
Tracking Time
Time Tracking Reporting
ℹ️Support and Best Practices
❓Frequently Asked Questions
Pro Tips
New Client Onboardings
Cleanups
What class is this for?
Transactions that need receipts
Bank Statement Requests
Trust Account Reconciliation (IOLTAs)
Misc.
Changelog
Catch up with Keeper Webinars
July 2021 Design Update
Keeper's Sidebar
What is Keeper?
Zapier
Korean dramas we recommend
Docs powered by archbee 
16min

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.

Marking this Zoom transaction as reviewed will hide it in the Expense Inconsistency report, but it may still appear open in other reports.
Marking this Zoom transaction as reviewed will hide it in the Expense Inconsistency report, but it may still appear open in other reports.



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.

Document image

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

Document image

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.

Document image

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



Updated 18 Aug 2022
Did this page help you?
Yes
No
UP NEXT
Bulk Editing
Docs powered by archbee 
TABLE OF CONTENTS
Transaction Status
The More Information Button
Report Exclusion Lists
Adding and removing reports
Date ranges