Bill.com reports are an important tool for you to use to gather information quickly and accurately. Each report focuses on a different area of Bill.com 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 | Parameters | Variables | Output |
---|---|---|---|---|
Bill Payments | List of all payments recorded and/or paid in Bill.com | Includes type "other" and voided payments. | - Also includes the Disbursement reference if an ACH and the check number if a Bill.com Check payment. - Does not include scheduled payments. - Scheduled payments won't appear on this report. |
- 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 | - Includes open balance of all bills including partially paid bills. - Aging date is calculated based on the Invoice Date and the date of the report. |
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) | - Calculated based on Invoice date (must be before the specified date on the report). - Pending payments aren't included in payment calculations. - Will pull all open bills with an invoice date on or before the date of the report. - Total paid doesn't include pending payments |
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. | - Calculated based on Invoice date (must be before the specified date on the report). - Pending payments aren't included in payment calculations. - Includes everything with an invoice or process date before the date of the report |
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 | - Calculated based on Due Date - must be before the specified date on the report. (a bill with a date of today won't show up on a report run as of yesterday). - Pending payments aren't included in payment calculations. - Based on Due Date vs date of report. - Will only include bills with a invoice date on or before the date of the report, but the calculation for aging is based on due date. - If there are credits applied, the report needs to be run as of a date that is after the credit date and credit application date |
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 | - Calculated based on Due Date (must be before the specified date on the report - a bill with a date of today won't show up on a report run as of yesterday). - Pending payments aren't included in payment calculations. - Based on Due Date vs date of report. - Will only include bills with a invoice date on or before the date of the report, but the calculation for aging is based on due date. - If there are credits applied, the report needs to be run as of a date that is after the credit date and credit application date |
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 | Calculated according to Payment Process Date | 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 | - Calculated based on Invoice, process, or credit date and whether there was a successful sync. - Will pull what has or hasn't synced to Quickbooks Desktop (doesn't work for other Accounting Software). - Transactions that haven't synced will show up in the not-exported report. |
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 |
Bill Approval Audit | Contains the current and historical approval summary and applicable payment details per bill | - Calculated based on Create Date or Process date. - This report shows whether a bill has been approved, whether it's been paid, and who paid it. - The Bill ID in the first column is the Bill ID in the URL for the bill |
Date Range Filter By Transaction - Date - Created Date |
- Bill ID - Bill Created Date - Invoice Number - Vendor Name - Amount -B ill Status - Last Approved By - Last Approved Date - Next Approver - Approvals Requested - Approvals Completed - Due Date - Last Payment Date - Last Payer |
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 |
- Calculated based on process date. - Will show the total amount of the payments processed on a certain date |
Date Range | - Process date - Amount - Bank - Account (last four digits of account used to pay) |
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 |
- Calculated based on process date. - Will show the total amount of the payments processed on a certain date and the invoices that were paid |
Date range Group by: - Date - Vendor Report Format: - HTML - 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 |
|
Purchase Orders | Available if PO's are enabled in account. | Date Range - End Date - Start Date |
- Vendor Name - Date - PO # - PO Status -Description - Amount |
Receivables Reports
Report Name | Report Description | Parameters | Variables | Output |
---|---|---|---|---|
Open Invoices Report | List of all open invoices | Will pull invoices with an invoice date on or before the date of the report. BUT the aging is based on the Date of the report - the Due Date. If the Due date is today, the Aging will be Zero. | - 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 | - Toggle on or off the ability to see inactive customers. Each contact for the customer is listed here. - If a contact hasn't set up a payment method in the portal, the payment method will be listed as Check. |
NA | - Customer - City - State - Zip Code - Contact (name) - 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 | - Toggle on or off the ability to see customers with a zero or negative balance. - Payment statuses that have synced from Quickbooks Desktop won't be calculated on this report |
Date range Sort by: - Customer - Balance Report Format: - HTML - 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 | Payment statuses that have synced from Quickbooks Desktop won't be calculated on this report | Date range Sort by: - Date - Type - Customer - Balance Report Format: - HTML - CSV |
- Type - Invoice - Payment etc. - Date - Invoice Number - Amount - Balance - Subtotal (per customer) - Total (all customers) |
AR Aging Summary | List of outstanding invoices | - Based on the date of the report vs the due date. - Payment statuses that have synced from Quickbooks Desktop won't reflect on this report. -Doesn't include partially paid 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 aren't included in this report |
AR Aging Detail | Detailed list of outstanding invoices | - Based on the date of the report vs the due date. - Payment statuses that have synced from Quickbooks Desktop won't be calculated on this report - Doesn't include partially paid 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 don't show up in this report). |
- Calculated based on the DEPOSIT DATE. -Does not include BR payments |
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 don't show up in this report). |
- Calculated based on the Deposit Date. - Does not include BR payments |
Date range Group by: -Date - Customer Report Format: - HTML - 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. | Calculated based on the Process Date | Date Range - Start date - End date Funding Type: - All - Credit Card - ePayment - Check - Cash - 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. | Based on Create Date | - 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. | Based on Create Date | - 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 GP. |
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 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 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 won't always match due to each being calculated differently