Product Mapping Accountant

Every line of a supplier invoice must post to a GL account of your chart. Accounting → Product Mapping says which account each product posts to, per company — one QuickBooks file, one chart of accounts. The page does not compute anything: it shows the account the export will use today.

app.nexreps.com
Product Mapping
18 unmapped · 240 inherited · 35 mapped for this company
1Search a product...Bluefin Hospitality Inc.Unmapped
4 products bought in the last 30 days post nowhere — an export would refuse their invoices. Filter on Unmapped to set their accounts.
22 selectedSet accountCancel
☐  ProductCategoryAccountLast boughtStatus
☑  Halibut filletHarbour Seafood LtdSeafoodSet an accountNov 3Unmapped
☑  Oysters, East CoastHarbour Seafood LtdSeafoodSet an accountNov 4Unmapped
☐  LemonsNorthfield ProduceProduce3Set an accountNov 2Unmapped
☐  Heavy cream 35%Old Mill DairyDairyCost of Goods Sold:FoodSupplier defaultNov 5Inherited
  1. 1Search, pick the company, filter by status.
  2. 2Tick one product or many, then Set account.
  3. 3A product with no account: click the cell to set one.

Reading the page

Pick the company. The header counts the products that are unmapped, inherited and mapped for this company.

Each row is an active product with its suppliers, its category, the Account it posts to and where that account comes from, the day it was Last bought, and its Status:

Mapped — an account set for this company. Inherited — no account for this company, so it falls back on the product’s default or the supplier’s default; the account cell says which (Product default, Supplier default). Unmapped — it posts nowhere.

Filter on All products, Unmapped, Inherited (product or supplier default) or Mapped for this company, and search by name.

Before an export

When products bought in the last 30 days post nowhere, a banner says how many: an export would refuse their invoices. Filter on Unmapped and set their accounts first.

Setting an account

Click the account cell of a product, or tick several and Set account. Pick the GL account, then Save on N products. The list offers the company’s expense, cost of goods and inventory accounts only — not the bank.

No company mapping (fall back to the product or supplier account) clears the choice: the product goes back to its default.

app.nexreps.com
Product Mapping
18 unmapped · 240 inherited · 35 mapped for this company
Account for 2 products
1
Cost of Goods Sold:Food — Seafood ▾
No company mapping (fall back to the product or supplier account)
Cost of Goods Sold:Food — Seafood✓
Cost of Goods Sold:Food — Produce
Cost of Goods Sold:Beverage
Cancel2Save on 2 products
  1. 1The GL account, from this company’s chart.
  2. 2Save on 2 products.

If the list is empty, the company has no chart of accounts yet: import it on Entities first.

Next

Export to QuickBooks — sending the month’s invoices.