Aantar

Aantar Books

List reports

Printable lists of your customers, vendors, items, prices and staff: contact lists, phone lists, the item price list, the item listing and the employee contact list.

Where: Reports ▸ List · Reports ▸ Report Centre ▸ Lists

The List reports turn your lists into something you can print, export or hand out: a price list for a customer, a phone list for the office, a contact list for your accountant, or the full item listing with costs, prices and margins. They have no dates, because a phone number or a price is simply what it is today; only the two contact lists take an As of date, for their Balance column.

Where to find them

  • Reports ▸ List: Account Listing, Item Listing, Item Price List, Customer Contact List, Customer Phone List, Vendor Contact List, Vendor Phone List and Employee Contact List.
  • Reports ▸ Report Centre, category Lists.

Account Listing, the first item on the menu, is filed with the accountant's reports in the Report Centre and is explained in Accountant & Taxes reports.

These reports have no filters: each lists everything of its kind. To narrow one down, use the search box, Filter or column sorting in the report toolbar, then print or export what is shown. See Running a report and Print, export and email a report.


Customer

Customer Contact List

What it answers: every customer, with how to reach them, their terms and what they owe you.

Date: as of a day (today unless you choose another).

Columns:

Column What it shows
Customer The customer's business name, or their name when there is no business name.
Ref The customer's reference number.
Contact The person's name, when the customer is a business.
Phone Mobile, or landline when there is no mobile.
Email Email address.
Address Street, city, province and postal code.
Terms Payment terms, for example 30 days, or On receipt.
Balance What the customer owes you on the As of date: open invoices, opening balances and General Journal charges, less credit memos and payments not yet applied. The same figure as the Customer Balance Summary. A negative balance is a credit the customer holds.

Rows: every customer (including contacts set up as both customer and vendor), alphabetically, then a TOTAL of the balances.

Drill down: double-click a customer to open their ledger.

Note: Counter sales to the Walk-In Customer are not counted in its balance, as on the Customer Balance Summary. For what is owed invoice by invoice, and how late, use the A/R Aging reports in Customers & Receivables reports.

Customer Phone List

What it answers: just the numbers.

Date: none.

Columns: Customer, Mobile, Landline and Alternate.

Rows: every customer, alphabetically. The subtitle counts them.

Drill down: double-click a customer to open their ledger.

Vendor

Vendor Contact List

What it answers: every vendor, with how to reach them, their terms and what you owe them.

Date: as of a day (today unless you choose another).

Columns: the same as the Customer Contact List, with Vendor in place of Customer. Balance is what you owe the vendor on the As of date: open bills, opening balances and General Journal entries, less vendor credits and payments not yet applied, the same figure as the Vendor Balance Summary.

Rows: every vendor (including contacts set up as both customer and vendor), alphabetically, then a TOTAL of the balances.

Drill down: double-click a vendor to open their ledger.

Note: For which bills are open and how late, use A/P Aging Summary in Vendors & Payables reports.

Vendor Phone List

Columns: Vendor, Mobile, Landline and Alternate.

Rows: every vendor, alphabetically.

Drill down: double-click a vendor to open their ledger.

Item

Item Price List

What it answers: your selling prices, ready to hand to a customer.

Date: none.

Columns: Item, Code, Unit, Price (before tax) and Price inc. tax.

Rows: grouped by category (items with none are under Uncategorised). Inactive items and items marked as not for selling are left out, so the list is safe to share.

Drill down: double-click an item to open it.

Tip: Hide the column you do not want customers to see (for example Price inc. tax for business customers) with Columns before printing.

Note: The prices are the items' standard selling prices. Prices set by Price Levels are not shown.

Item Listing

What it answers: every item, with its cost, price, margin and stock: the catalogue as an accountant reviews it.

Date: none.

Columns:

Column What it shows
Item The item (and its variant, where it has variants).
Code Its SKU or code.
Category Its category.
Brand Its brand.
Tax code The sales tax code on the item.
Cost The item's cost.
Price Its selling price.
Margin % (Price less cost) as a share of the price, the way retail quotes margin. It is not a markup on cost.
On hand Quantity across every location; blank for items that do not track stock.
Status Active or Inactive.

Rows: every item, active and inactive, alphabetically. The subtitle counts them.

Drill down: double-click an item to open it. Click its On hand figure to open Inventory Valuation Detail for that item: every movement in and out, which explains how the quantity came to be.

Related: The Item List; Inventory reports for stock values.

Employee

Employee Contact List

What it answers: everyone with a user account in your company, and how to reach them.

Date: none.

Columns: Employee, Username, Email, Phone, Location, Commission % (for staff set up as sales reps) and Status.

Personal identifiers such as Social Insurance Numbers are deliberately not shown, because contact lists get printed and left on desks.

Drill down: double-click a person to open Sales by Rep Detail for them. Someone with no sales opens an empty report.

Related: Set Up Users and Roles; payroll details are in the Employee Centre.


Common problems

A customer or vendor is missing. Deleted contacts are not listed. Check the Customer Centre or Vendor Centre.

An item is missing from the Item Price List. It is inactive or marked as not for selling. It is still on the Item Listing.

The balance on a contact list differs from the aging report. Check that both use the same date. The contact list also takes off payments received but not yet applied to an invoice or bill, which the aging reports leave out; they show on the customer's or vendor's statement.

Related articles

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