Financial Reports
Throughout Billingbooth there are a range of reports available to you to help with any analytical requirements you might have. In this article, we'll go over all the currently available financial related reports and where to find them.
Aged debtors
Found at:
Click Reports in the main-navigation
Usage:
Aged debtors is a list of customers with outstanding invoices. The report lists all amounts as gross (amount + tax), and breaks it down by time periods.
Filtered By:
Organisation
Columns in Excel Export:
Customer Name, Reference, 0 - 30 days, 31 - 60 days, 61 - 90 days, >90 days, Total
Customer balances
Found at:
Click Reports in the main-navigation
Usage:
Returns a full list of all customers and their current balances at this point in time.
Columns in Excel Export:
Customer Name, Reference, Status, Debit, Credit
Customer Specific: Customer balance
Found at:
Click Customers > Customers in the main-navigation, click a customer name to go to their overview screen, and then click Balance in the top-navigation, followed by the Export button at the top-right of the Running balance panel.
Usage:
Returns a full list of debit and credit ledger entries assigned to this customer.
Filtered By:
Customer Name/Customer Reference
Columns in Excel Export:
Date, Activity, Details, Debit, Credit, Balance
Payments
Found at:
Click Payments in the main-navigation, followed by the Export button at the top-right of the Payments panel.
Usage:
Returns a full list of all payments.
Filtered By:
Provider, Status, Source, Organisation, Created Date, Charge Date
Columns in Excel Export:
Created, Last Updated, Charge Date, Customer Name, Customer Reference, Organisation, Payment Amount, Details, Retry attempts, Retry Date, Source, Provider, Provider Reference, Settlement Mode, Payment Status, Invoice Number, Invoice Date, Billing Period, Invoice Amount, Invoice Tax, Remaining Balance, Invoice Status
Unallocated Credits
Found at:
Click Reports in the main-navigation
Usage:
Returns a full list of all customer credit ledger entries that have not been fully allocated, including the amount that remains unallocated.
Filtered By:
Organisation
Columns in Excel Export:
Customer Name, Customer Reference, Entry Date, Description, Details, Amount, Allocated, Unallocated
Transactions
Found at:
Click Reports in the main-navigation
Usage:
Returns a full list of all customer ledger entries between the specified date periods.
Filtered By:
Organisation, Transaction Type, Filter by (Creation date/Entry date), Date Range
Columns in Excel Export:
Customer Name, Customer Reference, Entry Date, Created, Type, Amount, Exc. Tax, Tax, Description, Details
Settlement
Found at:
Click Reports in the main-navigation
Usage:
The settlement lag gives you an overview on the average time to settle invoices.
Revenue estimate
Found at:
Click Reports in the main-navigation
Usage:
This report is based on the currently active service charges. It does not take into consideration Voice, Data & SMS charges, it will most likely not take into account service file charges, it does not forecast or analyse historical trends to forecast future charges, and as such it should be utilised for a simple snapshot of the lifecycle of existing charges.
Columns in Excel Export:
Customer Name, Customer Reference, <Month Year>*
*There will be 12 columns for each month in the last year.
Customer margins
Found at:
Click Reports in the main-navigation
Usage:
Returns a full 12-month view across your entire customer base on the overall sell/cost pricing as well as margin percentages.
Columns in Excel Export:
Customer Name, Reference, Type, <Month Year> (Revenue, Cost, Margin)*
*There will be 12 columns for each month in the last year.
Customer revenue
Found at:
Click Reports in the main-navigation
Usage:
Returns an aggregated sell and buy price of all products broken down by customer.
Filtered By:
Date Range, Tags, Product, Organisation
Columns in Excel Export:
Customer Name, Customer Reference, Product Name, Product Reference, Sell Price, Buy Price, Margin (%)
Category revenue
Found at:
Click Reports in the main-navigation
Filtered By:
Tags
Usage:
Returns the total revenue, excluding tax, broken down by the categorised values.
Product revenue
Found at:
Click Reports in the main-navigation
Usage:
Returns the total revenue, excluding tax, broken down by the product values.
Filtered By:
Tags, Product
Supplier revenue
Found at:
Click Reports in the main-navigation
Usage:
Returns the total revenue, excluding tax, broken down by the supplier values.
Filtered By:
Tags
Invoices
Found at:
Click Invoices > Invoices in the main-navigation, followed by the Report button at the top-right of the Customer Invoices panel where you can then either select the Simple or Detailed report.
Usage:
Simple - Returns a full list of all invoices.
Detailed - Returns a detailed breakdown of all line items across all invoices, including charges that may have since been deleted from customers if they were included in past invoices.
Filtered By:
Status, Organisation, Issue Date, Billing Period, Invoice Number
Columns in Excel Export:
Simple - Invoice Number, Customer Name, Customer Reference, Issue Date, Due Date, Settled Date, Overdue Days, Amount, Tax, Total, Balance, Status.
Detailed - Invoice Number, Invoice Status, Invoice Issue Date, Description, Period Start, Period End, Quantity, Sell Price, Tax, Tax Rate, Cost, Total Sell Price, Total Cost, Customer Name, Customer Reference, Customer Type, Regular Settlement By, CLI, Accounting Code, Product Name, Product Reference, Category Name, Supplier Name, Cost Centre Name, Cost Centre Reference, Service File Charge
Customer Specific: Invoices
Found at:
Click Customers > Customers in the main-navigation, click a customer name to go to their overview screen, and then click Invoices > Invoices in the top-navigation, followed by the Report button at the top-right of the Customer Invoices panel where you can then either select the Simple or Detailed report.
Usage:
Simple - Returns a full list of all invoices assigned to this customer.
Detailed - Returns a detailed breakdown of all line items across all invoices assigned to this customer.
Filtered By:
Status, Issue Date, Billing Period, Invoice Number
Columns in Excel Export:
Simple - Invoice Number, Customer Name, Customer Reference, Issue Date, Due Date, Settled Date, Overdue Days, Amount, Tax, Total, Balance, Status.
Detailed - Invoice Number, Invoice Status, Invoice Issue Date, Description, Period Start, Period End, Quantity, Sell Price, Tax, Tax Rate, Cost, Total Sell Price, Total Cost, Customer Name, Customer Reference, Customer Type, Regular Settlement By, CLI, Accounting Code, Product Name, Product Reference, Category Name, Supplier Name, Cost Centre Name, Cost Centre Reference, Service File Charge
Credit Notes
Found at:
Click Invoices > Credit Notes in the main-navigation, followed by the Report button at the top-right of the Credit Notes panel.
Usage:
Returns a full list of all credit notes.
Filtered By:
Date Range, Credit Note Number, Organisation
Columns in Excel Export:
Credit Note Number, Description, Customer Name, Customer Reference, Invoice, Reference, Date, Amount, Tax, Total
Payment plans
Found at:
Click Payments in the main-navigation, and then click Payment Plans in the top-navigation, followed by the Export button at the top-right of the Payment Plans panel.
Usage:
Returns a list of all payment plans.
Columns in Excel Export:
Customer Name, Customer Reference, Scheduled Amount, Start Date, Number Of Payments, Frequency, First Payment Amount, Status, Has Failed Payments, Notes
Customer Specific: Payment plans
Found at:
Click Customers > Customers in the main-navigation, click a customer name to go to their overview screen, and then click Payments > Payment Plans in the top-navigation, followed by the Export button at the top-right of the Payment Plans screen.
Usage:
Returns a list of all payment plans relating to this customer.
Columns in Excel Export:
Customer Name, Customer Reference, Scheduled Amount, Start Date, Number Of Payments, Frequency, First Payment Amount, Status, Has Failed Payments, Notes