Reports Overview

Key CashFlow reports are an important tool for you to use to gather information quickly and accurately. Each report focuses on a different area of Key CashFlow and pulls the information based on specific filters.

Select Reports in the navigation menu to access a variety of reports for reviewing Payables and Receivables.

Jump to:


Payables Reports

Report Name Report Description Variables

Output

Bill Payments List of all payments recorded and/or paid in Key CashFlow
  • Date range
  • Payment type:
    • Offline
    • Online
  • Report format:
    • CSV
  • Process Date (of payment)
  • Vendor
  • Invoice Number
  • Payment Reference (Payment Confirmation Number)
  • Payment Method
  • Disbursement Reference
  • Payment Amount
  • Subtotal (per Vendor)
  • Grand Total (of all payments for given date range)
Unpaid Bills List of all unpaid bills
  • End date (determines the 'as-of' date)
  • Vendor
  • Invoice #
  • Date (of bill)
  • Due Date
  • Aging
  • Approval Status
  • Payment Status
  • Open Balance
Vendor Balance Summary of outstanding Vendor balances (money owed to Vendors)
  • Date Range
  • Sort by:
    • Vendor
    • Balance
  • Report Format:
    • CSV
  • Vendor
  • Total Billed
  • Total Paid
  • Total Credits
  • Balance (for each Vendor)
  • Total
Vendor Balance Details List of Vendor balances, with breakdown of Bills and Payments for each Vendor.
  • Date Range
  • Sort by:
    • Date
    • Type
  • Report Format:
    • CSV
  • Type
    • Bill
    • Payment
    • etc.
  • Date
  • Invoice Number / Payment Ref
  • Disbursement Reference
  • Amount
  • Balance (for each Vendor)
AP Aging Summary Aging of Accounts Payable
  • End date (determines the 'as-of' date)
  • Vendor
  • Due Date Status:
    • Current
    • Overdue (by number of days):
      • 1 - 30
      • 31 - 60
      • 61 - 90
      • 91+
    • Total (per Vendor)
    • Grand Total
AP Aging Detail Report Detailed look at the aging of Accounts Payable
  • End date (determines the 'as-of' date)
  • Status (Approval status of Bill)
  • Payment Status
  • Invoice #
  • Date
  • Vendor
  • Due Date
  • Aging Period
  • Open Balance
Transaction List by Vendor List of all transactions, grouped by Vendor
  • Date range
  • Report Format:
    • CSV
  • Type
    • Bill
    • Payment
    • etc.
  • Date
  • Invoice Number / Payment Reference
  • Disbursement Reference
  • Amount
Transaction List by Export Status List of all transactions, grouped by Vendor, and filterable by export status
  • Date range
  • Filter by:
    • Exported
    • Not Exported
  • Sort by:
    • Approval Status
    • Date
    • Not for Export
  • Report Format:
    • CSV
  • Approval Status
  • Type
  • Date
  • Due Date
  • Vendor
  • Invoice Number
  • Payment Reference
  • Amount
  • Allow Export
Funds Transfer for Key CashFlow Payments List of withdrawals from your bank account (Funds Transfer) made by Key CashFlow to pay bills on your behalf. Also includes deposits from voided payment credits
  • Date Range
  • Process date
  • Amount
  • Bank Account (last four digits of account used to pay)
Bill Approval Audit Contains the current and historical approval summary and applicable payment details per bill
  • Date Range
  • Filter By
    • Transaction Date
    • Created Date
  • Bill ID
  • Bill Created Date
  • Invoice Number
  • Vendor Name
  • Amount
  • Bill Status
  • Last Approved By
  • Last Approved Date
  • Next Approver
  • Approvals Requested
  • Approvals Completed
  • Due Date
  • Last Payment Date
  • Last Payer
Funds Transfer Detail for Key CashFlow Payments Shows a breakdown of which bills were paid with each withdrawal from your bank account (Funds Transfer). Also includes deposits from voided payment credits
  • Date range
  • Group by:
    • Date
    • Vendor
  • Report Format:
    • HTML
    • PDF
    • CSV
  • Vendor Name
  • Invoice #
  • Process Date
  • Disbursement #
  • Due Date
  • Amount
  • Bank Account (last four digits of account used to pay)
  • Subtotal (per Vendor)
  • Total (for all Vendors)


Receivables Reports

Report Name Report Description Variables Output
Open Invoices List of all open invoices
  • End Date (determines the 'as-of' date)
  • Customer
  • Invoice #
  • Invoice Date
  • Due Date
  • Sales Rep
  • Aging
  • Open Balance
Customer Activity Summary Details of customer activity in Customer Portal NA
  • Customer
  • City
  • State
  • Zip Code
  • Contact (name)
  • Email
  • Phone
  • Last Invoice Sent (date)
  • Last Login (date)
  • Last Payment Sent (date)
  • Payment Methods
  • Auto Charge
  • Authorized (for auto charge - yes/no)
Customer Balance Summary of outstanding balances
  • Date range
  • Sort by:
    • Customer
    • Balance
  • Report Format:
    • HTML
    • PDF
    • CSV
  • Customer
  • Total Invoice Amount
  • Total Paid Amount
  • Balance
Customer Balance Detail Shows a detailed list of which invoices make up outstanding balances for each Customer
  • Date range
  • Sort by:
    • Date
    • Type
    • Customer
    • Balance
  • Report Format:
    • HTML
    • PDF
    • CSV
  • Type
    • Invoice
    • Payment
    • etc.
  • Date
  • Invoice Number
  • Amount
  • Balance
  • Subtotal (per customer)
  • Total (all customers)
AR Aging Summary Report List of outstanding invoices
  • End Date (determines the 'as-of' date)
  • Customer
  • Current balances (by aging period)
    • 1 - 30
    • 31 - 60
    • 61 - 90
    • 91+
  • Subtotal (per customer)
  • Grand Total
  • Unapplied payments are not included in this report
AR Aging Detail Report Detailed list of outstanding invoices
  • End Date (determines the 'as-of' date)
  • Invoice #
  • Date
  • Customer
  • Due Date
  • Aging
  • Open Balance
Funds Transfer for ePayments Received Shows a list of the deposits made to your bank account by Key CashFlow. Each deposit consists of payments made to your company by Customers through the Customer Portal (payments made to you through a Network connected account do not show up in this report).
  • Date range
  • Start date
  • End date
  • Process Date
  • Amount
  • Bank Account (last four digits of account used to receive ePayments)
Funds Transfer Detail for ePayments Received Shows a list of the deposits made to your bank account by Key CashFlow, in a given time period. Each deposit consists of payments made to your company by Customers through the Customer Portal (payments made to you through a Network connected account do not show up in this report).
  • Date range
  • Group by:
    • Date
    • Customer
  • Report Format:
    • HTML
    • PDF
    • CSV
  • Customer Name
  • Process Date
  • Disbursement #
  • Amount
  • Bank Account (last four digits of account used to receive ePayments
  • Subtotal (per customer)
  • Total (all customers)
Received Payments List of all received payments recorded in Key CashFlow in a given time period.
  • Date Range
  • Start Date
  • End Date
  • Funding Type:
    • All
    • Credit Card
    • ePayment
    • Check
    • Cash
    • PayPal
    • Other
  • Payment type:
    • Online Payment
    • Offline
  • Payment Date
  • Customer
  • Reference Number
  • Payment Method
  • Online (Yes/No)
  • Convenience Fee
  • Total Payment Amount
Invoice Details Report Detailed list of Invoices in a given time period.
  • Start date
  • End date
  • Customer
  • Customer ID
  • Invoice Date
  • Invoice Number
  • Invoice Description
  • Account Number
  • Account
  • Department
  • Item
  • Memo line
  • Credit
Credit Memo Details Report Detailed list of Credit Memos in a given time period.
  • Start date
  • End date
  • Customer
  • Customer ID
  • Credit Date
  • Reference Number
  • Credit Memo Description
  • Account Number
  • Account
  • Item
  • Memo line
  • Credit
  • Department Id

Export Reports

Report Name Report Description Variables Output
Payables Cash Detail Export Creates a file that exports detailed journal entries with payment activity and corresponding bills and vendor credits.
  • Date Range
  • Start Date
  • End Date
  • Filter by:
    • Transaction date
    • Created date

Generates .CSV file based on selected variables; optimized for use in Microsoft Great Plains.

Thomson Reuters Write-up CS Summary Export Creates a file that exports a summary of transactions by account for a selected reporting period for Thomson Reuters Write-up CS solution
  • Start Date
  • End Date
  • Transaction Date
  • Reference
  • Description
  • Month

Generates .GLT file based on selected variables, for use in Thomson Reuters.

Thomson Reuters Write-up CS Detail Export Creates a file that exports detailed transactions by account and vendor for a selected reporting period for Thomson Reuters Write-up CS solution
  • Start Date
  • End Date
  • Reference
  • Month

Generates .GLT file based on selected variables, for use in Thomson Reuters.

Accrual Summary Report List of all accounts with the total debits, credits, and net change
  • Date Range
  • Start Date
  • End Date
  • Filter by:
    • Transaction date
    • Created date
  • Account
  • Account Name
  • Debit
  • Credit
  • Net Change
  • Account Number
Accrual Detail Report Shows a detailed list of paid transactions per vendor for each Account
  • Date Range
  • Start Date
  • End Date
  • Filter by:
    • Transaction date
    • Created date
  • Vendor
  • Ref # (reference number)
  • Account
  • Account Name
  • Txn Date (transaction date)
  • Debit
  • Credit
  • Net Change
  • Account Number
  • Department
Cash Summary Report Displays movement of cash into and out for chosen period
  • Date Range
  • Start Date
  • End Date
  • Filter by:
    • Transaction date
    • Created date
  • Account
  • Account Name
  • Debit
  • Credit
  • Net Change
  • Account Number
Cash Detail Report Details of cash flow for chosen period
  • Date Range
  • Start Date
  • End Date
  • Filter by:
    • Transaction date
    • Created date
  • Vendor
  • Ref # (reference number)
  • Account
  • Account Name
  • Txn Date (transaction date)
  • Debit
  • Credit
  • Net change
  • Account Number
  • Department
Unpaid Accrual Summary Report Overview of unpaid transactions
  • End Date (determines the 'as-of' date)
  • Expense Account
  • Account Number
  • Total
Unpaid Accrual Detail Report Detailed view of unpaid transactions
  • End Date (determines the 'as-of' date)
  • Vendor
  • Invoice #
  • Date
  • Due Date
  • Amount
  • Expense Account
  • Account Number
  • Department
  • Customer

Exportable pages

These pages within Key CashFlow are exportable under the More actions menu:

  • Payments In in the navigation menu
  • Payments Out in the navigation menu
  • Invoices in the navigation menu
  • Bills in the navigation menu
  • Invoices on the customer record
  • Payments on the customer record
  • Bills on the vendor record
  • Payments on the vendor record

Things to know

  • If the customer syncs with QuickBooks Desktop, Account Receivables reports may not be accurate if they are entering payments in QuickBooks Desktop and syncing the status to Key CashFlow
  • Some reports are calculated based on the date the bill or invoice was created
  • If there isn't a report in the reports tab with the information needed, the Import/Export tool can typically be used to obtain the data
  • The Overview Reports and the Reports Tab reports won't always match due to each being calculated differently