Skip to main content

How to Upload AR Sales Invoices to Tofu and Sync Them with QuickBooks Online

This guide shows how to upload AR invoices to Tofu, keep data in sync with QuickBooks Online, and train Tofie AI

Written by Jess B
Updated over 2 weeks ago

1. Turn on AR Invoice as an Extraction Type

  1. Go to Entity Settings β†’ Features.

  2. Under Document Extraction Types, toggle AR Invoice ON.

Once enabled, Tofu will extract customer details, invoice numbers, dates, amounts, and line items from every AR invoice you upload.


2. Configure AR Invoice Settings for QuickBooks Online

Connect and configure your QuickBooks integration:

  1. Go to Settings β†’ Integrations β†’ QuickBooks.

  2. Open the QuickBooks configuration panel.

  3. Go to AR Invoices, choose your settings and click Activate to save.

πŸ’‘ Recommended Settings

  • Auto-publish – Tofu automatically sends extracted AR invoices to QuickBooks Online.

  • Auto-import – Updates from QBO sync back into Tofu, including AR invoice status changes (e.g., paid or partially paid), customer updates, line item corrections (quantity, rate, description), and tax adjustments.

  • Self-Prompt – For newly added entities, Tofie learns from your accounting data and applies your rules automatically.

    • Note: For existing entities that already have a QBO integration, Self-Prompt won’t appear in the QuickBooks configuration settings. To update it, go to:
      ​Settings β†’ Entity Knowledge Base β†’ Select AR Invoices β†’ Click Self-Prompt

These settings help Tofie AI keep your data clean and consistent across both systems, reducing manual work.


3. Upload an AR Invoice

You can upload AR invoices automatically via a cloud integration or manually from your computer.

  1. Go to your Source Document column.

  2. Click Upload document.

  3. Select your AR invoice file.

πŸ’‘ Recommended: Connect Google Drive or SharePoint
For the easiest AR invoice workflow, we recommend integrating Google Drive or SharePoint with Tofu. Once connected, any invoices you upload to your chosen folder will automatically sync into Tofu, so you don’t have to upload documents manually every time.


4. Review the extracted data and verify

Once the AR invoice is extracted:

  1. Go to the Extractions column.

  2. Review the extracted data, including:

    1. Customer

    2. Invoice Number

    3. Invoice Title

    4. Reference (if applicable)

    5. Currency

    6. Tax Amount

    7. Dates (Invoice Date, Due Date)

    8. Line Items (description, quantity, rate, service date)

      πŸ’‘ Note: Service Date appears only if it is enabled in your QuickBooks Online sales invoice settings. You can leave it blank if not applicable.

  3. Before verifying or publishing to QuickBooks Online, make sure the following fields are correct:

    • Customer – Must be assigned to a valid customer.

    • Invoice Date – Cannot be blank.

    • Due Date – Must not be earlier than the Invoice Date.

    • Line Item Description – Required if no product/service is selected.

    • Currency - Cannot be blank.

  4. If you spot anything that’s wrong or missing, edit the fields directly in Tofu (you can adjust customer, dates, line items, and more).

  5. Once everything looks correct, click Verify.

πŸ’‘ Tips:

Keep both systems in sync
You don’t need to update the same invoice twice. When auto-publish and auto-import is enabled, changes you make in QuickBooks Online (QBO) can flow back into Tofu, and allowed changes you make in Tofu can flow into QBO. You can work in whichever platform is more convenient, without duplicating edits.

Account Type Visibility

To show Account Type automatically next to account names:

1. Go to Entity Settings β†’ Features β†’ Accounting

2. Enable Account Type

3. Return to review β€” Account Type will show automatically.

If this setting is disabled, click the β€œ+” icon in the Account column to view Account Type.

πŸ’‘ Tips & Tricks: Train Tofie AI for Your Preferred AR Invoice Format

You can train Tofie to follow your preferred AR invoice formatting so everything stays consistent. For example:

  • Adding β€œINV” at the beginning of every AR invoice number

  • Automatically translating line item descriptions from other languages into English

Here’s how to set it up:

  1. Click Tofie in the upper-right corner of Tofu.

  2. In the Knowledge Type dropdown, select the transaction type β€” for this example, choose AR Invoices.

  3. In the prompt box, enter what you want Tofie to generate knowledge. For example:

    • β€œPut INV before invoice number and translate line description to English for AR Invoices"

  4. Click Generate to teach Tofie your instructions

  5. Click Save.

Once generated, this rule is saved to your Entity Knowledge and will automatically be applied to all AR invoices you upload going forwardβ€”no additional steps needed.

With AR invoices flowing from Tofu to QuickBooks Online and staying in sync, you’ll spend less time on manual data entry and more time focusing on your customers and your business. πŸš€πŸ’Ό Happy bookkeeping! πŸ“ŠπŸ˜„

Did this answer your question?