Reports Overview – Support

Bill.com reports are an important tool for customers to use to extrapolate information quickly and accurately. Each report focuses on a different area of Bill.com and pulls the information based on specific parameters.

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
Receivables Reports
Export Reports
Exportable pages
Things to Know

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: 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 Balances	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 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 Detail 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)
Unrealized Foreign Exchange Gain and Loss	Show amounts per unpaid or partially paid foreign currency bill, as well as a total amount of potential gains and losses from these bills based on the exchange rate at the time of bill creation, and the end date selected by you	End Date	Vendor Name Invoice Number Bill Date Bill Amount Bill Balance FX rate on bill Bill Balance (USD) FX rate on (end date) Balance On (end date) Gain & Loss in USD
Foreign Currency Paid Gain and Loss	Show amounts per unpaid or partially paid foreign currency bill, as well as a total amount of actual gains and losses from these bills based on the exchange rate at the time of bill creation, and the exchange rate at the time of payment	End Date Start Date Filter by: Transaction date Created date	Vendor Name Invoice Number Bill Paid Amount in FX FX rate on bill Bill Amount in USD FX rate on Payment Day Payment Amount in USD Gain & Loss in USD

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 Unapplied payments are not included in this report
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
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 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

Exportable pages

These pages within Bill.com are exportable under the More actions menu:

Payments In on the left navigation pane
Payments Out on the left navigation pane
Invoices on the left navigation pane
Bills on the left navigation pane
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 for Windows, Account Receivables reports may not be accurate if they are entering payments in QuickBooks for Windows and syncing the status to Bill.com
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 will not always match due to each being calculated differently

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.

Welcome to the all-new Help Center

Payables Reports

Receivables Reports

Export Reports

Exportable pages

Things to know

Related articles