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

 

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

 

 

Have more questions? Submit a request
Powered by Zendesk