Receipt Bot data extraction setting

Understanding the various requirements for data extraction, Receipt Bot empowers you to tailor the settings to align the data extraction process according to your preferences. You can define rules on how you want to record each document type or turn on/off the extraction of additional data, the treatment of duplicate documents, and several other options. This article provides an overview of configuring data extraction rules in the Receipt Bot.

We can divide the extraction settings into the following categories;

1. Accounting & Export Rules for Different Documents
2. Bank Statement Extraction
3. Document Management
4. Supplier Statement & Ledger Extraction

1. Accounting & export rules for different documents

Receipt Bot intelligently categorises each purchase or sale invoice into specific document types during the data extraction, such as payment confirmation receipts, tax invoices, checks, and more.

Globally, businesses follow diverse practices when it comes to recording transactions. For example, while one business may log a transaction upon receiving an order confirmation, another might only do so upon receiving the tax invoice. These practices can vary depending on specific supplier or customer interactions.

You can establish rules in Receipt Bot on how a transaction should be exported or recorded within the system or even to external accounting software to ensure alignment with your unique business preferences.

[imageframe lightbox=”yes” gallery_id=”” lightbox_image=”https://www.receipt-bot.com/assets/video/manage-data-extraction-rules/slide-1.JPG” style_type=”none” bordercolor=”” bordersize=”0px” borderradius=”0″ stylecolor=”” align=”center” link=”” linktarget=”_self” animation_type=”0″ animation_direction=”down” animation_speed=”0.1″ animation_offset=”” class=”” id=””][/imageframe]

You can find more details by exploring the following article on mapping document types to transaction types in Receipt Bot: Define accounting transactions for different document types.

2. Bank statement extraction

2.1. Extract additional account info.

Receipt Bot extracts basic account information from the uploaded bank or card statements, such as the Payment Method’s display name, Account Title, and the Last four digits of the Payment Method.

Should you require the extraction of additional account details, including the Bank Address, Bank Phone Number, Account Holder’s Name, Account Holder’s Phone Number, and Account Holder’s Address, you may enable this feature by following these steps:

Step 1 – Navigate to the “Data Extraction Setting” tab.

[imageframe lightbox=”yes” gallery_id=”” lightbox_image=”https://www.receipt-bot.com/assets/video/manage-data-extraction-rules/slide-2.JPG” style_type=”none” bordercolor=”” bordersize=”0px” borderradius=”0″ stylecolor=”” align=”center” link=”” linktarget=”_self” animation_type=”0″ animation_direction=”down” animation_speed=”0.1″ animation_offset=”” class=”” id=””][/imageframe]

Step 2 – Enable the “Extract Additional Account Info” switch.

[imageframe lightbox=”yes” gallery_id=”” lightbox_image=”https://www.receipt-bot.com/assets/video/manage-data-extraction-rules/slide-3.JPG” style_type=”none” bordercolor=”” bordersize=”0px” borderradius=”0″ stylecolor=”” align=”center” link=”” linktarget=”_self” animation_type=”0″ animation_direction=”down” animation_speed=”0.1″ animation_offset=”” class=”” id=””][/imageframe]

Step 3 – Click the “Confirm” button.

[imageframe lightbox=”yes” gallery_id=”” lightbox_image=”https://www.receipt-bot.com/assets/video/manage-data-extraction-rules/slide-4.JPG” style_type=”none” bordercolor=”” bordersize=”0px” borderradius=”0″ stylecolor=”” align=”center” link=”” linktarget=”_self” animation_type=”0″ animation_direction=”down” animation_speed=”0.1″ animation_offset=”” class=”” id=””][/imageframe]

The extraction of additional account information will be enabled.

The system will now extract the additional payment method information for any new documents.

[imageframe lightbox=”yes” gallery_id=”” lightbox_image=”https://www.receipt-bot.com/assets/video/manage-data-extraction-rules/slide-5.JPG” style_type=”none” bordercolor=”” bordersize=”0px” borderradius=”0″ stylecolor=”” align=”center” link=”” linktarget=”_self” animation_type=”0″ animation_direction=”down” animation_speed=”0.1″ animation_offset=”” class=”” id=””][/imageframe]

The same information will be available for download using the Standard Excel format.

[imageframe lightbox=”yes” gallery_id=”” lightbox_image=”https://www.receipt-bot.com/assets/video/manage-data-extraction-rules/slide-6.JPG” style_type=”none” bordercolor=”” bordersize=”0px” borderradius=”0″ stylecolor=”” align=”center” link=”” linktarget=”_self” animation_type=”0″ animation_direction=”down” animation_speed=”0.1″ animation_offset=”” class=”” id=””][/imageframe]

2.2. Process attached checks separately

Bank statement scans frequently contain checks attached at the end of the file, detailing the transactions that have occurred. With Receipt Bot, you can extract data from these checks separately, utilising the Purchase Invoice Module. This information is then recorded as payment confirmation of your supplier’s invoice. Receipt Bot intelligently identifies and segregates these attached checks during processing, treating them as individual purchase invoices when this feature is enabled.

To take advantage of this functionality, please follow these steps:

Step 1 – Navigate to the “Data Extraction Settings” tab.

[imageframe lightbox=”yes” gallery_id=”” lightbox_image=”https://www.receipt-bot.com/assets/video/manage-data-extraction-rules/slide-7.JPG” style_type=”none” bordercolor=”” bordersize=”0px” borderradius=”0″ stylecolor=”” align=”center” link=”” linktarget=”_self” animation_type=”0″ animation_direction=”down” animation_speed=”0.1″ animation_offset=”” class=”” id=””][/imageframe]

Step 2 – Enable the “Process Attached Checks Separately” switch.

[imageframe lightbox=”yes” gallery_id=”” lightbox_image=”https://www.receipt-bot.com/assets/video/manage-data-extraction-rules/slide-8.JPG” style_type=”none” bordercolor=”” bordersize=”0px” borderradius=”0″ stylecolor=”” align=”center” link=”” linktarget=”_self” animation_type=”0″ animation_direction=”down” animation_speed=”0.1″ animation_offset=”” class=”” id=””][/imageframe]

The setting will be enabled, and any new statement uploaded with checks will now be split into multiple documents. A separate document will be created for each check attached and processed as a payment confirmation in the purchase invoice module.

[imageframe lightbox=”yes” gallery_id=”” lightbox_image=”https://www.receipt-bot.com/assets/video/manage-data-extraction-rules/slide-9.JPG” style_type=”none” bordercolor=”” bordersize=”0px” borderradius=”0″ stylecolor=”” align=”center” link=”” linktarget=”_self” animation_type=”0″ animation_direction=”down” animation_speed=”0.1″ animation_offset=”” class=”” id=””][/imageframe]

2.3. Auto delete exported bank statements

The ‘Auto Delete Statement’ feature allows you to automatically remove bank statement data after a specified period, reducing any data confidential risks. It can also speed up the Receipt Bot’s performance. For detailed instructions on enabling this feature, please refer to the following: Auto delete bank statements in Receipt Bot.

3. Document management

3.1. Block duplicate file upload

Receipt Bot can identify duplicate documents upon upload, and using this setting, you can configure Receipt Bot to block any duplicate files or allow upload.

By default, this setting is switched on for a business to save your credits. You can follow these steps to turn off the feature:

Step 1 – Navigate to the “Data Extraction Settings” tab.

[imageframe lightbox=”yes” gallery_id=”” lightbox_image=”https://www.receipt-bot.com/assets/video/manage-data-extraction-rules/slide-10.JPG” style_type=”none” bordercolor=”” bordersize=”0px” borderradius=”0″ stylecolor=”” align=”center” link=”” linktarget=”_self” animation_type=”0″ animation_direction=”down” animation_speed=”0.1″ animation_offset=”” class=”” id=””][/imageframe]

Step 2 – Navigate to the “Document Management” section on the right.

[imageframe lightbox=”yes” gallery_id=”” lightbox_image=”https://www.receipt-bot.com/assets/video/manage-data-extraction-rules/slide-11.JPG” style_type=”none” bordercolor=”” bordersize=”0px” borderradius=”0″ stylecolor=”” align=”center” link=”” linktarget=”_self” animation_type=”0″ animation_direction=”down” animation_speed=”0.1″ animation_offset=”” class=”” id=””][/imageframe]

Step 3 – Disable the “Block Duplicate File Upload” switch.

[imageframe lightbox=”yes” gallery_id=”” lightbox_image=”https://www.receipt-bot.com/assets/video/manage-data-extraction-rules/slide-12.JPG” style_type=”none” bordercolor=”” bordersize=”0px” borderradius=”0″ stylecolor=”” align=”center” link=”” linktarget=”_self” animation_type=”0″ animation_direction=”down” animation_speed=”0.1″ animation_offset=”” class=”” id=””][/imageframe]

The duplicate files will be uploaded to the Receipt Bot.

3.2. Auto delete duplicate document

Receipt Bot also checks the extracted data to identify duplicates, and you can opt to have these duplicate documents automatically deleted to save credits. This feature is turned off by default.

If this setting is enabled, the system will process duplicate documents with a Duplicate flag.

[imageframe lightbox=”yes” gallery_id=”” lightbox_image=”https://www.receipt-bot.com/assets/video/manage-data-extraction-rules/slide-13.JPG” style_type=”none” bordercolor=”” bordersize=”0px” borderradius=”0″ stylecolor=”” align=”center” link=”” linktarget=”_self” animation_type=”0″ animation_direction=”down” animation_speed=”0.1″ animation_offset=”” class=”” id=””][/imageframe]

If this setting is disabled, the system will delete duplicate documents with relevant remarks.

[imageframe lightbox=”yes” gallery_id=”” lightbox_image=”https://www.receipt-bot.com/assets/video/manage-data-extraction-rules/slide-14.JPG” style_type=”none” bordercolor=”” bordersize=”0px” borderradius=”0″ stylecolor=”” align=”center” link=”” linktarget=”_self” animation_type=”0″ animation_direction=”down” animation_speed=”0.1″ animation_offset=”” class=”” id=””][/imageframe]

To enable this feature, please follow these steps:

Step 1 – Navigate to the “Data Extraction Settings” tab.

[imageframe lightbox=”yes” gallery_id=”” lightbox_image=”https://www.receipt-bot.com/assets/video/manage-data-extraction-rules/slide-15.JPG” style_type=”none” bordercolor=”” bordersize=”0px” borderradius=”0″ stylecolor=”” align=”center” link=”” linktarget=”_self” animation_type=”0″ animation_direction=”down” animation_speed=”0.1″ animation_offset=”” class=”” id=””][/imageframe]

Step 2 – Enable the “Auto Delete Duplicate Document” switch.

[imageframe lightbox=”yes” gallery_id=”” lightbox_image=”https://www.receipt-bot.com/assets/video/manage-data-extraction-rules/slide-16.JPG” style_type=”none” bordercolor=”” bordersize=”0px” borderradius=”0″ stylecolor=”” align=”center” link=”” linktarget=”_self” animation_type=”0″ animation_direction=”down” animation_speed=”0.1″ animation_offset=”” class=”” id=””][/imageframe]

Once enabled, all duplicate documents will be moved to the recycle bin with the relevant delete reason.

3.3. Auto reclassify

Receipt Bot’s document classification feature simplifies your workflow. When you upload a document to a module different from its identified class (purchase, sale, or statement), with the “Auto-reclassify” feature enabled, the system will reclassify the document to the correct module.

Suppose you accidentally submitted a bank statement in the Purchase Invoice module. Receipt Bot will swiftly reclassify it to the Bank Statement module, where it will undergo transaction extraction. This intelligent system ensures your documents are always in the right place for efficient processing.

This setting is enabled by default in the Receipt Bot. To turn off the auto reclassify feature, follow these steps:

Step 1 – Navigate to the “Data Extraction Settings” tab.

[imageframe lightbox=”yes” gallery_id=”” lightbox_image=”https://www.receipt-bot.com/assets/video/manage-data-extraction-rules/slide-17.JPG” style_type=”none” bordercolor=”” bordersize=”0px” borderradius=”0″ stylecolor=”” align=”center” link=”” linktarget=”_self” animation_type=”0″ animation_direction=”down” animation_speed=”0.1″ animation_offset=”” class=”” id=””][/imageframe]

Step 2 – Click the “Auto Reclassify” switch to turn off the feature.

[imageframe lightbox=”yes” gallery_id=”” lightbox_image=”https://www.receipt-bot.com/assets/video/manage-data-extraction-rules/slide-18.JPG” style_type=”none” bordercolor=”” bordersize=”0px” borderradius=”0″ stylecolor=”” align=”center” link=”” linktarget=”_self” animation_type=”0″ animation_direction=”down” animation_speed=”0.1″ animation_offset=”” class=”” id=””][/imageframe]

The reclassification will be turned off, and if a document is uploaded to the incorrect module, it will not be reclassified; instead, the system will flag the document with Error and add processing notes like “Unrecognized Type: The document not recognized as an invoice or receipt.”

[imageframe lightbox=”yes” gallery_id=”” lightbox_image=”https://www.receipt-bot.com/assets/video/manage-data-extraction-rules/slide-19.JPG” style_type=”none” bordercolor=”” bordersize=”0px” borderradius=”0″ stylecolor=”” align=”center” link=”” linktarget=”_self” animation_type=”0″ animation_direction=”down” animation_speed=”0.1″ animation_offset=”” class=”” id=””][/imageframe]

3.4. Period lock

The ‘Period Lock Date’ feature in Receipt Bot allows you to establish a specific date to secure the authenticity and consistency of your financial data. Once configured, Receipt Bot restricts any modifications to your data before the defined ‘Period Lock Date’ to ensure the reliability and accuracy of your financial information, particularly for tasks like VAT/TAX filing.

You can follow these steps to set up the period lock date:

Step 1 – Navigate to the “Data Extraction Settings” tab.

[imageframe lightbox=”yes” gallery_id=”” lightbox_image=”https://www.receipt-bot.com/assets/video/manage-data-extraction-rules/slide-20.JPG” style_type=”none” bordercolor=”” bordersize=”0px” borderradius=”0″ stylecolor=”” align=”center” link=”” linktarget=”_self” animation_type=”0″ animation_direction=”down” animation_speed=”0.1″ animation_offset=”” class=”” id=””][/imageframe]

Step 2 – Click the “Period Lock” switch.

[imageframe lightbox=”yes” gallery_id=”” lightbox_image=”https://www.receipt-bot.com/assets/video/manage-data-extraction-rules/slide-21.JPG” style_type=”none” bordercolor=”” bordersize=”0px” borderradius=”0″ stylecolor=”” align=”center” link=”” linktarget=”_self” animation_type=”0″ animation_direction=”down” animation_speed=”0.1″ animation_offset=”” class=”” id=””][/imageframe]

Step 3 – Enter the period lock date.

[imageframe lightbox=”yes” gallery_id=”” lightbox_image=”https://www.receipt-bot.com/assets/video/manage-data-extraction-rules/slide-22.JPG” style_type=”none” bordercolor=”” bordersize=”0px” borderradius=”0″ stylecolor=”” align=”center” link=”” linktarget=”_self” animation_type=”0″ animation_direction=”down” animation_speed=”0.1″ animation_offset=”” class=”” id=””][/imageframe]

Step 4 – Click the “Confirm” button.

[imageframe lightbox=”yes” gallery_id=”” lightbox_image=”https://www.receipt-bot.com/assets/video/manage-data-extraction-rules/slide-23.JPG” style_type=”none” bordercolor=”” bordersize=”0px” borderradius=”0″ stylecolor=”” align=”center” link=”” linktarget=”_self” animation_type=”0″ animation_direction=”down” animation_speed=”0.1″ animation_offset=”” class=”” id=””][/imageframe]

The period lock setting will be enabled. Any document whose invoice date is before the period lock can not be edited.

[imageframe lightbox=”yes” gallery_id=”” lightbox_image=”https://www.receipt-bot.com/assets/video/manage-data-extraction-rules/slide-24.JPG” style_type=”none” bordercolor=”” bordersize=”0px” borderradius=”0″ stylecolor=”” align=”center” link=”” linktarget=”_self” animation_type=”0″ animation_direction=”down” animation_speed=”0.1″ animation_offset=”” class=”” id=””][/imageframe]

If you upload new documents with the invoice date before the period lock, they will be processed with an error flag and will not be included in reports.

[imageframe lightbox=”yes” gallery_id=”” lightbox_image=”https://www.receipt-bot.com/assets/video/manage-data-extraction-rules/slide-25.JPG” style_type=”none” bordercolor=”” bordersize=”0px” borderradius=”0″ stylecolor=”” align=”center” link=”” linktarget=”_self” animation_type=”0″ animation_direction=”down” animation_speed=”0.1″ animation_offset=”” class=”” id=””][/imageframe]

4. Supplier Statement / Sale Ledger / Cash Register Extraction

With Receipt Bot’s Supplier Statement & Ledger Extraction feature, you can create transactions from supplier statements/transaction ledgers/cash registers.

Refer to the following article to further understand the Supplier Statement and Sale Ledger extraction setting: Convert statements or ledgers to invoices.

Frequently Asked Questions

[accordian divider_line=”” class=”articleKB_faq” id=””]

[toggle title=”Q: What is the purpose of the Receipt Bot data extraction setting?” open=”yes”]
A: Receipt Bot’s data extraction setting allow you to customize data extraction according to your preferences.[/toggle]

[toggle title=”Q: Can I choose to extract additional account information from my bank statement pdf?” open=”yes”]
A: You can extract additional account information, such as bank address, customer address, and account holder’s name, by enabling the ‘extract additional account information’ setting.[/toggle]

[toggle title=”Q: Can I setup auto-deletion of duplicate documents in Receipt Bot?” open=”yes”]
A: You should enable the ‘Block Duplicate File Upload’ and ‘Auto Delete Duplicate Document’ settings.[/toggle]

[/accordian]

Related help articles

Auto delete bank statements in Receipt Bot

Convert statements or ledgers to invoices