AviBooks — Knowledge Base

AviBooks reconciles your books against bank/credit-card statements and proves every line with a receipt. You import a statement (and optionally a ledger), attach receipts, hit Reconcile, and export a colour-coded result — or a file ready for QuickBooks, Sage, Caseware, or TaxCycle.

Tip: click any section heading to collapse it, or use the search box above. All figures and names below are made-up examples.

🧭 The big picture ▾

Work flows top-to-bottom through four steps, with everything organised by Company → Account → Month.

Pick a period. Choose the company, the account (Visa, Chequing…), and the month.

Import ledgers. Load the bank/credit-card statement (and a book ledger if you have one).

Attach proof. Drop in receipts & invoices; the engine reads each one.

Reconcile & export. Match, review the colours, and export.

1 · Company → Account → Month ▾

The top-right corner (and Step 1) is a cascade. Pick the company, then the account by type, then the month.

Company: Sample Co. Ltd ▾ Account: Visa ▾ Month: March 2026 ▾

Choose Company (or “All companies”). A statement auto-creates its company on import.

Choose the Account — shown by type (Visa, Mastercard, Chequing…). Two of the same type show a ••1234 tag.

Choose the Month. Each month is its own period.

Recognition: if a statement says a card brand it’s a Visa/Mastercard/Amex; if it only shows an account number with no card, it’s a chequing account. You can have several chequing accounts.

2 · Import statements & ledgers ▾

Use ⚡ Load statement(s) to drop in one or many statements at once — each is identified (bank, account, dates) and routed to the right month automatically.

Or in Step 2, Choose statement file(s) / book file(s) — you can select several files together.

Loading several files into one account: the first replaces that side, the rest are merged in. Tick “Add to existing” to append instead of replace. Supported: PDF, CSV, XLSX.

3 · Attach proof (receipts) ▾

In Step 3, Choose images / PDFs — select multiple receipts/invoices at once.

The engine reads vendor, date and amount, and links each receipt to its matching line automatically.

Each doc shows when it was loaded and a read-accuracy chip (green ≥85%, amber ≥60%, red below).

A line with no auto-match? Click it → 🔗 Link a receipt to attach one by hand. The link is sticky.

4 · Reconcile & the colour legend ▾

Click Run reconciliation. Every line gets a status colour:

🟢 matched — amounts agree & proof attached 🟦 payment — card payment (transfer from chequing) 🔵 fee — bank fee / interest 🔴 discrepancy — statement line, no book record 🟣 outstanding — book line not yet on the statement

TransactionsShow: All ▾⚙ Categories⛶ Full screen

Date	Description	Amount	Status	Category	Type
Mar 15	SOFTWARE VENDOR	$125.00	matched	Software & Subscriptions	Business
Mar 02	PAYMENT – THANK YOU	$1,000.00	payment	Credit Card Payment	—
Mar 11	COFFEE SHOP #1234	$6.50	discrepancy	Food & Beverages	Business

Click All in the legend to clear it, then turn statuses on one by one; click All again to show everything.

🏷️ Categories & Business / Personal ▾

Every line is auto-categorised by vendor and given a Business/Personal suggestion. Both are editable dropdowns (in the grid and the side panel), and your choice sticks across re-reconciles.

Category: Gas / Fuel ▾ Type: Business ▾

Click ⚙ Categories to open the manager.

Add / rename / delete categories, and add vendor rules (keyword → category, with an optional default type).

New rules apply to existing lines on the next reconcile. Renaming a category updates everything tagged with it.

🧾 Marked receipts ▾

When a receipt matches, its PDF is stamped RECONCILED (green badge, top-right) and the matching amount & date are highlighted yellow — shown in the viewer, the download, and the embedded Excel image.

RECONCILED · Match #3
2026-03-15 | $125.00
Date & amount match this receipt

Amount paid $125.00

Date paid March 15, 2026

📤 Export ▾

After reconciling, Step 4 offers several exports:

↓ Annotated Excel — colour-coded workbook with categories & types.

↓ Excel + receipts — the same, plus each matched receipt embedded on a Receipts sheet (works offline).

Prepare for export → pick a package, then ↓ Export:

Prepare for export → QuickBooks Desktop / Enterprise (IIF) ▾ ↓ Export

QuickBooks Desktop / Enterprise (Canada & US) — an .IIF General Journal.
Sage 50 (Canada & US), Caseware, TaxCycle — CSV.
Generic CSV — a plain debit/credit file for anything else.

Each line carries its category as the offsetting account, so on first import you just map categories to your chart of accounts.

🖥️ Handy view options ▾

⛶ Full screen — expand the grid; the Company/Account/Month pickers stay available at the top. Press Esc to exit.
Resize columns — drag a column’s right edge; widths are remembered.
Show: All / Business / Personal / Unassigned — filter the grid by type.

🐞 Found a bug? Have an idea? ▾

Use the floating 🐞 Bug and 💡 Idea buttons (bottom-right of the app) to record it on the board. Mark items done or delete them when handled.