Automated expense reports in Receipt Bot

You can quickly analyze your purchases using the automated expense reports in Receipt Bot. The reports are available once the data is extracted from submitted scan copies of your bills, receipts, or supplier statements. These Expense Reports can quickly evaluate monthly costs and break down your costs by different dimensions.

Steps to Review Expense Report

First, you must submit scan copies of your bills, receipts, or supplier statements to Receipt Bot. Once the data is generated from these documents, the expense reports will be populated on your Receipt Bot account.

To access the Expense Report, please follow these steps:

Step 1 – Navigate to the Purchase Invoices page using the business menu.

Step 2 – Navigate to the Reports page using the tab menu at the top.

Step 3 – Select the report type using the Report drop-down.

The Expense Reports types are designed to summarize the purchase data from different perspectives. The page contains four reports, which are the following;

1. 1. Summary by Supplier: Provides a breakdown of cost by contact/supplier. The report will show the expenses under the “Miscellaneous Supplier” if a supplier cannot be extracted from documents.
   2. Summary by Category: Provides a breakdown of cost by expense categories.
   3. Summary by VAT: A breakdown of the VAT amount by VAT rate is provided. You can further drill down to a break up by Category for each VAT rate.
      
   4. Summary by User: It provides a breakdown of costs by the user who submitted the bills.
      Pro-tip: This report can be used to manage expenses for your staff members. Onboard your staff members to Receipt Bot and ask them to submit their expenses by uploading bills/receipts to Receipt Bot. The system will extract data from these bills/receipts and prepare a report by users.
      

Step 4 – Select the last period and the number of previous periods.

1. 1. • The last period specifies the date until the data should be included in the report.
      • The number of previous periods is used to generate comparative columns against the last period so you can analyze any trends.

Step 5 – Apply filters by Document Type, Record As, Customer Name, and Document Status.

Step 6 – Click the grid download icon to download the filtered report in CSV format.

Pro-tip: This will allow you to access the report using any spreadsheet software like Microsoft Excel. You can perform additional analysis as needed.

Frequently Asked Questions

Related help articles

Automate VAT/GST Summary preparation with Sale & Purchase Invoices

Review purchase invoices in Receipt Bot