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:
- QuickBooks Online, on Accounting > Bank transactions.
- The folder your scanner saves to (for example a shared Google Drive folder). Scanned paper bills arrive there with names like
Scanned_YYYYMMDD-HHMM.pdf. - Each supplier's online account, on its Billing or Invoices page, for bills you get online.
- One folder on your computer where you save every bill PDF before attaching it.
Steps
- In QuickBooks, open Accounting > Bank transactions.
- Click the card for the bank account or credit card the money left from.
- Stay on the For review tab.
- Type a search in the box above the list: the supplier's name, a code from the bank description, or the amount.
- Note the date and amount of the line.
- 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).
- 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.
- 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.
- Back in QuickBooks, click the line to open it. Leave Categorize selected.
- Check Supplier/Customer. QuickBooks sometimes suggests the wrong supplier; change it if it did.
- Check Account and Tax (see Coding examples below).
- Click Add attachment and pick the PDF from your bills folder.
- Wait until the file name shows next to Add attachment (it reads "Uploading..." first).
- Click Add. The line leaves For review, and the count on the account card drops by one.
- 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:
- YYYYMMDD: the date on the bill.
- SUPPLIER: the supplier's name in capitals. If you have several accounts with the same supplier, add the account's short code after the name.
- NUMBER: the invoice number. If the bill shows only an account number, use that.
- AMOUNT: the amount, with a dot for decimals.
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 bill | Where the bill comes from | Account | Tax |
|---|---|---|---|
| Electricity | Paper bill, scanned | Utilities | TPS/TVQ QC - 9,975 |
| Internet and phone | Supplier's online account | Utilities | TPS/TVQ QC - 9,975 |
| Software subscription billed in US dollars | Supplier's online account | Software Expenses | Exonéré (0%) |
| Repairs | Paper receipt, scanned | Repair and maintenance | TPS/TVQ QC - 9,975 |