Aantar

Aantar Books

Batch Enter Transactions

Type or paste many cheques, deposits, card charges, bills, invoices or credits from a spreadsheet, check them, and save them all in one go.

Where: Accountant ▸ Batch Enter Transactions…

Batch Enter Transactions is a spreadsheet-style grid for entering many transactions at once. It suits catching up a backlog, or entering a month of bank statement lines, without opening a form for each one. Every document you save goes through the same entry path as the normal form, so the closing date, permissions and numbering rules are the same.

Opening it

Accountant ▸ Batch Enter Transactions…

Choose what you are entering

Under Enter, choose the kind of transaction. Each kind has its own columns.

Kind Columns
Checks Date, Check No., Payee, Account, Amount, Tax Code, Memo, Class
Deposits Date, No., Received From, From Account, Amount, Memo
Credit Card Charges Date, No., Vendor, Account, Amount, Tax Code, Memo, Class
Credit Card Credits Date, No., Vendor, Account, Amount, Tax Code, Memo
Bills Date, Ref. No., Vendor, Account, Item, Qty, Rate, Amount, Tax Code, Memo, Class
Bill Credits Date, Ref. No., Vendor, Account, Amount, Tax Code, Memo
Invoices Date, Invoice No., Customer, Item, Qty, Rate, Tax Code, Memo, Class
Credit Memos Date, Credit No., Customer, Item, Qty, Rate, Tax Code, Memo

For cheques and deposits, choose the Bank account above the grid; for card charges and credits, the Credit card account. Changing the kind clears the grid, because each kind has different columns, and asks you first.

Fill the grid

  • One row is one line. Rows with the same number and name (and date) are the lines of one document. A row that leaves the date, number and name blank continues the document above it.
  • Paste from a spreadsheet. Copy the cells in your spreadsheet, click a cell, and press Ctrl+V, or click Paste from Excel. If the first row you paste is the column titles, in any order, Aantar Books places each column by its title and names any title it does not know.
  • Dates may be yyyy-mm-dd, yyyy/mm/dd or mm/dd/yyyy. Amounts may carry a dollar sign and commas, and a negative may be written (12.00) or 12-.
  • Type the payee, account, item, tax code and class as they are named in your lists. An account can be its number, its name, or Parent:Child; an item its SKU or name; a tax code its name or its percentage. If a name matches more than one thing, or nothing, the row is refused with a sentence that says which.

Check, then save

  1. Click Check Transactions. Aantar Books reads every row and shows in the Result column what it would refuse and why. Nothing is saved.
  2. Fix the rows that need it.
  3. Click Save Transactions. Each document is saved in order and its result appears on its row.

Saved documents leave the grid and are listed under Saved in this session. A row that was refused stays in the grid with the reason, and is saved on its own once you have fixed it. A summary line tells you how many were saved and how many were refused.

Never twice

Each document is remembered by its content. If you save the same rows again, they are answered duplicate and nothing new is posted. A changed row counts as a new document. If a saved document is later deleted, it can be entered again.

What to know

  • A batch is not all or nothing. Each document stands alone, so rows after a refused one are still saved. The summary lists which were not.
  • Up to 500 documents can be saved at once.
  • The closing date applies row by row. A row dated in a closed period is refused with the usual closing-date message.
  • Class is available on cheques, card charges, bills and invoices only. A row with a class on another kind is refused, not quietly dropped.
  • Invoices and credit memos take item lines. Bill credits, card credits and deposits take account lines. Bills take either.
  • This grid does not apply payments to invoices or bills, set terms or due dates, enter foreign currency amounts or attach files. Enter those on the normal forms.

Tip: Invoices and bills already in a spreadsheet with full detail may suit Import Invoices and Bills from Excel better.

Related articles

Something unclear or out of date? Write to support@aantar.com and name this page.