Sign in

Reports - Overview

We offer a variety of reports for analyzing 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
  • Payment 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)
  • 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:
    • 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 for Bill.com payments  List of withdrawals from your bank account (Funds Transfer) made by Bill.com 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 Details for Bill.com 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)

 

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

 

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 lump-sum deposits made to your bank account by Bill.com. Each lump-sum deposit consists of payments made to your company by Customers through the Customer Portal (payments made to you through another 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 another 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