gab.ae

QuickBooks Online: attach the bill to a bank transaction

Give every expense its receipt. Take one transaction at a time: find the bill, save it as a PDF with a clear name, attach it, check how the line is coded, and add it.

2 min 37 s, no sound: the captions explain each step. All names, numbers and amounts in the video are made up.

Before you start

Have these open in your browser, signed in:

Steps

  1. In QuickBooks, open Accounting > Bank transactions.
  2. Click the card for the bank account or credit card the money left from.
  3. Stay on the For review tab.
  4. Type a search in the box above the list: the supplier's name, a code from the bank description, or the amount.
  5. Note the date and amount of the line.
  6. Find the bill for that line:
    • Paper bill: open the scanner folder and open scans until one shows the same supplier and amount.
    • Online bill: on the supplier's Billing or Invoices page, find the bill by its date and click Download (on some sites you open the invoice first, then click the download icon).
  7. For a scan only: click the file name at the top of the viewer, type the new name (see File names below), and click OK.
  8. Click the download icon. In the Save As window, go to your bills folder, type the file name if it is not already there, and click Save.
  9. Back in QuickBooks, click the line to open it. Leave Categorize selected.
  10. Check Supplier/Customer. QuickBooks sometimes suggests the wrong supplier; change it if it did.
  11. Check Account and Tax (see Coding examples below).
  12. Click Add attachment and pick the PDF from your bills folder.
  13. Wait until the file name shows next to Add attachment (it reads "Uploading..." first).
  14. Click Add. The line leaves For review, and the count on the account card drops by one.
  15. Go to the next line.

If a line is already categorized but has no bill attached: open its expense, click Add attachment under Attachments, pick the PDF, then click Save and close.

File names

Name every bill YYYYMMDD - SUPPLIER - NUMBER - $AMOUNT.pdf:

A made-up example: 20260712 - INTERNET CO - INV123456 - $100.00.pdf

For a bill in a foreign currency, use the amount printed on the invoice, even though the bank line shows the converted amount.

Coding examples

This is how one company in Quebec coded a few kinds of bills. Your own accounts and tax codes come from your chart of accounts and your accountant.

Kind of billWhere the bill comes fromAccountTax
ElectricityPaper bill, scannedUtilitiesTPS/TVQ QC - 9,975
Internet and phoneSupplier's online accountUtilitiesTPS/TVQ QC - 9,975
Software subscription billed in US dollarsSupplier's online accountSoftware ExpensesExonéré (0%)
RepairsPaper receipt, scannedRepair and maintenanceTPS/TVQ QC - 9,975