Aantar Books
Bill lines: items, expenses, tax and landed costs
Every column on the Items and Expenses tabs of a bill, how to choose which item columns show (with the screen-only amount and cost with tax), how tax is worked out on each line, and how to add freight and duty to the cost of stock.
Where: Vendors ▸ Enter Bills · Vendors ▸ Create Purchase Orders
A bill has two tabs of lines. The Items tab is for things on your Item List — stock you buy to sell, and services and non-stock items. The Expenses tab is for everything else, charged straight to an account: rent, hydro, the phone bill, a repair, freight billed on its own. One bill can use both. Each tab's name shows its running total, tax included (for example Expenses $226.00). This article covers every column on both tabs, the tax on each line, and the Freight & duty window that adds landed costs to your stock.
A purchase order has the Items tab only. Its lines work the same way.
The Items tab
Adding items
- Scan or type to add items (name / code)…: type two or more letters of the item's name, its variation or its SKU, or scan its barcode. The matches drop down under the box, each with its barcode, stock and cost. Use ↓ and ↑ to move and Enter to add, or click one. Enter with nothing highlighted adds the first match, which is how a barcode scan works.
- Adding an item that is already on the bill adds one to that line's quantity instead of a second line.
- Grid entry (size / colour): for items with size and colour variations, a grid where you type a quantity in each cell. Each filled cell becomes a line; cells already on the bill top up their line.
- Read the vendor's invoice: fills the lines from the vendor's PDF or photo. See Enter Bills.
The keyboard loop for a pile of bills: scan or type → Tab → QTY → Enter → COST → Enter back to the search box for the next item. Typing into QTY or COST replaces what is there.
Tab goes along a line in column order: LOCATION (or Expense account), Description, QTY, COST, DISC., TAX, CUSTOMER:JOB and CLASS, then the next line. From the last line it goes back to the search box. Tab passes over the BILLABLE tick box, the × button and the last paid … — tap to use link. Shift+Tab goes back the same way.
The columns
| Column | What to enter / what it means |
|---|---|
| LOCATION | For a stocked item: the location the goods are received into. Leave it to receive at your own location. For a service or non-stock item this column shows Expense account instead — see below. |
| ITEM | The item's name (double-click it for the item's full history, Product 360). Under it: Description — what the vendor's invoice called the line, if you want it kept; the SKU and last paid $… (date) — tap to use (what you paid last time) or catalogue cost $… — tap to use (the cost on the item, for an item never bought before); and the batch and serial fields when they apply. |
| QTY | How many you bought. Required and more than zero. |
| U/M | The unit the line is in: the item's own, or a larger unit picked from the arrow (a case of 10), which converts the cost and stocks the line in the item's own unit. See Units of measure and larger units. |
| COST | The vendor's price for one unit, before any discount on the line and before tax. It starts at the last price you paid. |
| DISC. | A discount the vendor gave on this item. Click it to give one, as a percentage or an amount per unit. The tax is worked out on the discounted price. Shows — when there is none. |
| TAX | The tax rate the vendor charged on this line. See Tax on each line. |
| GST/HST | The federal part of the line's tax (all of HST, where HST replaces both). Read-only, on screen only. See GST/HST and PST in two columns. |
| PST | The provincial part of the line's tax, headed RST in Manitoba, QST in Quebec and PST/QST when the lines carry more than one province's tax. Empty in a province with no provincial tax. Read-only, on screen only. |
| AMOUNT | Quantity × cost after the discount, before tax. |
| CUSTOMER:JOB | The customer or job this item was bought for, if any. |
| BILLABLE | Tick to charge this cost on to the Customer:Job. It then appears in Add Time/Costs when you invoice them. Available once a Customer:Job is chosen. |
| CLASS | The line's class. Shown when your company uses classes. |
| AMOUNT WITH TAX | Hidden until you tick it in Columns. The line's amount with its tax in it. On screen only. See Choosing the columns. |
| COST WITH TAX | Hidden until you tick it in Columns. One unit's cost, after the discount, with its tax. On screen only. |
| Columns button | At the right end of the headings. Chooses which columns the Items tab shows. |
| × | Deletes the line. Ctrl+Del, or right-click the line and choose Delete Line, does the same. |
On a narrow window the table scrolls sideways rather than squashing the item names.
Choosing the columns
Click the Columns button (the column icon at the right end of the headings), or right-click the headings, to choose which columns the Items tab shows. Untick a column to hide it and tick it to show it; the list stays open while you change several. ITEM, QTY and AMOUNT are always shown. Reset to default puts every column back.
Enter Bills and Create Purchase Orders each keep their own choice, on this computer, and it is there the next time you open the form. Hiding a column does not change the line: its location, discount, tax, Customer:Job and class are still saved with the bill. Tab passes over hidden columns.
Two columns are hidden until you tick them, and are on your screen only — never printed, never on the purchase order PDF or an emailed copy, never saved:
- AMOUNT WITH TAX: the line's amount plus the line's tax, the same figures the totals add up. 4 × 45.50 on GST 5% + BC PST 7% is 182.00 and 203.84 with tax.
- COST WITH TAX: one unit's cost after the discount, with its tax (50.96 in the same example).
A line with no tax, or an exempt code, shows its amount and cost unchanged. These work the same as on an invoice; see Amount with tax.
Expense account on a service line
A service, a fee or any item that does not track stock has no stock to put the cost into, so its LOCATION cell becomes Expense account. Click it and choose the account the cost is charged to (Charge "item" to). Only expense and cost of goods sold accounts are offered. Left empty on a new line, the cost goes to the item's own COGS account (set on the item), or else your default expense account, or else Cost of Goods Sold. It never goes to Inventory, because a service has no stock for a sale to take it back out of. If your company has no expense accounts, Aantar Books says so and points you to the Chart of Accounts.
Batch, expiry and serial numbers
If your company tracks batches or expiry dates (see Lot numbers and expiry), each line has:
- Batch / Lot no.: the batch printed on the goods. Leave it empty and Aantar Books labels it from the bill number.
- Mfg date (when your company records manufacturing dates) and Expiry date. An expiry date already passed is shown in red.
For an item with serial numbers, a received bill shows a SERIALS 0/N chip on the line. Click it and scan one serial for every unit. The chip turns green when every unit has one. The bill cannot be saved until it does. Serials are not asked for on a purchase order (or on a bill still Pending from an earlier version), because nothing has arrived yet. See Serial Number Lookup.
The Expenses tab
| Column | What to enter / what it means |
|---|---|
| ACCOUNT | The account the money is for. Type part of its name or number and pick it from the list under the box. Choosing an account fills the line's tax with the account's usual tax code, if it has one. |
| AMOUNT | The amount for this line. See EXCL. TAX. |
| TAX | The tax the vendor charged on this line. |
| GST/HST, PST | The line's tax as its federal and provincial parts, read-only, as on the Items tab. |
| EXCL. TAX | Ticked (the usual state on a bill): the amount you type is before tax, and tax is added on top. Unticked: the amount you type includes the tax; when you leave the box it is turned into the net amount, and the tax is shown beside it (type 113.00 at 13% and it becomes 100.00 with 13.00 tax). Available once the line has a tax rate. |
| MEMO | A note for the line. |
| CUSTOMER:JOB | The customer or job the cost is for. |
| BILLABLE | Tick to charge it on to the Customer:Job. |
| CLASS | The line's class, when your company uses classes. |
| × | Deletes the line (Ctrl+Del). Ctrl+Ins inserts a blank line above. |
A blank line always waits at the bottom; start typing in it to add another. Every line with an amount needs an account, or the bill will not save.
Tab goes along a line in column order, ACCOUNT, AMOUNT, TAX, MEMO, CUSTOMER:JOB and CLASS, and then onto the next line. It passes over the EXCL. TAX and BILLABLE tick boxes and the × button. In ACCOUNT, type part of the name or number and press Tab: the highlighted account goes on the line and the cursor moves to AMOUNT.
Tax on each line
Every line carries its own tax rate, because a bill records what the vendor actually charged:
- An item line starts with the item's own tax rate. In British Columbia, Saskatchewan and Manitoba that is often GST + PST; if the vendor did not charge PST (because you gave them your PST number for goods you resell), change the line to GST only.
- An Expenses line starts with the account's usual tax code.
- Set tax for all lines (above the item table when there is more than one line, and under the totals) sets one rate on every item line. Each line can still be changed afterwards.
- A line whose rate is not on this computer yet shows ?; the tax recorded is kept. See Enter Bills.
Tax on an item line is worked out on the cost after the line's discount. A discount off the whole bill (the DISCOUNT tile) comes off after tax and does not change it.
Recoverable tax (GST/HST, and QST in Quebec) goes to your input tax credit account. Provincial sales tax that cannot be claimed back is added to the cost of the goods or the expense. See Tax on invoices, bills and expenses.
Note: EXCL. TAX sets, line by line, whether the amount excludes tax. On Write Cheques and Credit Card Charges new lines start including tax; on a bill they start excluding it, because you are copying the vendor's net figures.
Freight and duty (landed cost)
For goods you import, the real cost of an item is the vendor's price plus the freight, duty, brokerage and insurance you paid to get it here. Freight & duty puts those charges on the lines of a saved bill, so each item's cost includes them.
Every charge is owed to somebody: the broker, customs or the carrier sends an invoice, and that invoice is a bill you pay in Pay Bills. Freight & duty enters that bill for you and puts it on the goods in one step, so the charge is added to the stock once and owed once. It is never counted twice, and nobody is left unpaid.
- Save the bill, then open it again.
- In the panel on the right, choose Freight & duty.
- Under CHARGES OWED TO A BROKER, CUSTOMS OR A CARRIER, choose Add a charge owed to…:
- Enter their invoice: choose who it is Owed to (the broker, customs or the carrier), type Their invoice no. and the Date, the Charge (Freight, Customs Duty, Brokerage, Shipping, Handling, Insurance or Other), the Amount before tax and the Tax they charged, then how to Spread it: By value (duty), Evenly per unit, By weight (freight), By volume, m³ (freight), By percentage (type a percentage for each line; they must add up to 100%, and the money each one comes to is shown beside it) or By hand (type an amount for each line; they must add up to the charge). When Landed Cost Clearing has sub-accounts, an Account box lets you send their bill's line to one of them, for example Landed Cost Clearing:Customs Duty Clearing; leave it on the landed cost account otherwise. Choose Add. Aantar Books enters their bill to Landed Cost Clearing, owed to them in Pay Bills, and puts the amount on these goods. Recoverable GST/HST goes to the input tax credit as usual; tax that is not recoverable, such as PST, goes on the goods with the charge.
- Their bill is entered: when you have already entered their bill (to Landed Cost Clearing), choose it under Their bill, with how much of it goes on these goods. Nothing new is owed.
- Under What each line costs, check the cost of one unit of each item: the vendor's price, plus its share (+ $… landed), and the new cost per unit.
Each charge is listed with its type, who it is owed to and their invoice number, and, when some of the goods were already sold, how much went to Cost of Goods Sold. A charge added this way is saved at once. The × beside it takes it off these goods; their bill stays owed and waits in Vendors ▸ Landed Cost to be put on goods again. Delete their bill in Enter Bills if it was entered by mistake. A broker's bill spread over several bills' goods is taken off in Vendors ▸ Landed Cost.
Freight on this bill itself. When the vendor charged freight on this very bill (its shipping), that freight is already owed to them here. Under FREIGHT ON THIS BILL, Use this bill's $… puts it on the goods: choose how to Spread it and Apply to this bill. Only this bill's own freight can be put on the goods this way; for anything more, add the charge with who it is owed to. Aantar Books says so if you try.
Putting a charge on the goods adds it to the value of the stock (debit Inventory) and takes it out of the account the charge was entered to (credit Landed Cost Clearing). On average cost, the share for goods already sold goes to Cost of Goods Sold instead (for example $400 of a $1,000 charge on goods 40% sold); on FIFO, sales that already used the stock are re-costed. See Landed Cost. Aantar Books can refuse, for example when a bill is in a closed period or no Landed cost or Freight-in account is set up in Accounting Setup; the reason is shown in the window, and nothing is entered.
Note: The broker's bill is entered to the landed cost account and allocated to the item receipts or bills. Aantar Books can enter their bill for you from the goods bill, or you can enter it first and allocate it in Vendors ▸ Landed Cost.
Freight & duty is on a saved bill in Aantar Books only. Charges on goods later returned to the vendor go back to the freight account.
Common problems
Stock went up but the item's cost looks too low. The shipping on the bill is charged to Freight-in, not added to the stock. To include it in the cost of the goods, use Freight & duty.
A service on an older bill is in Inventory. Bills entered before Aantar Books charged an unchosen service line to its expense account left it on Inventory. Open the bill, click the line's Expense account cell, choose the account and save.
The Expenses line total is not what I typed. You typed a tax-inclusive amount with EXCL. TAX ticked, so tax was added on top. Untick EXCL. TAX and type the amount again.
I cannot save because of serials. A serial-numbered item needs one serial for every unit. Click the SERIALS chip and scan the rest, or reduce the quantity.
Related articles
- Enter Bills
- Create Purchase Orders
- Tax on invoices, bills and expenses
- Add Time/Costs
- Item accounts
- Lot numbers and expiry
Related articles
Something unclear or out of date? Write to support@aantar.com and name this page.