Reports Overview

We offer a variety of reports for reviewing Payables and Receivables. Below is a detailed list of reports available in Bill.com, with their respective uses, variables, and outputs.

Payables Reports

Report Name Report Description Variables

Output

Bill Payments List of all payments recorded and/or paid in Bill.com
  • Date range
  • Payment type:
    • Offline
    • Online
  • Report format:
    • HTML
    • PDF
    • CSV
  • Process Date (of payment)
  • Vendor
  • Invoice Number
  • Payment Reference (for ePayments)
  • Payment Method
  • Disbursement Reference
  • Payment Amount
  • Subtotal (per Vendor)
  • 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
  • Open Balance
Vendor Balances Summary of outstanding Vendor balances (money owed to Vendors)
  • Date Range
  • Sort by:
    • Vendor
    • Balance
  • Report Format:
    • HTML
    • PDF
    • 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:
    • HTML
    • PDF
    • 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)
  • Invoice #
  • Date
  • Vendor
  • Due Date
  • Aging Period
  • Open Balance
Transaction List by Vendor List of all transactions, grouped by Vendor
  • Date range
  • Report Format:
    • HTML
    • PDF
    • 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:
    • HTML
    • PDF
    • CSV
  • Approval Status
  • Type
  • Date
  • Due Date
  • Vendor
  • Invoice Number
  • Payment Reference
  • Amount
  • Allow Export
Funds Transfers List of withdrawals from your bank account (Funds Transfer) made by Bill.com to pay bills on your behalf
  • Date Range
  • Process date
  • Amount
  • Bank Account (last four digits of account used to pay)
Funds Transfer Details Shows a breakdown of which bills were paid with each withdrawal from your bank account (Funds Transfer)
  • 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 Report 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 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
AR Aging Detail 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 Bill.com. Each deposit consists of payments made to your company by Customers through the Customer Portal (payments made to you through an actual Bill.com 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 breakdown of which invoices were paid with each lump-sum deposit to your bank account (Funds Transfer), in a given time period. Each lump-sum deposit consists of payments made to your company by Customers through the Customer Portal (payments made to you through an actual Bill.com 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 your Bill.com account 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

Export Reports

Report Name Report Description Variables Output
Payables Cash Detail Report 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 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 (trransaction 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

If you do not see the described feature available in Bill.com, you may not have access to the feature based on permissions for your role and/or your plan does not have this feature. If you wish to get access to the feature, please review the available plans for Bill.com and upgrade accordingly or contact the Administrator of your Bill.com account. Changes in monthly user fees may apply.