BookTrove user guide · Chapter 7

7. Sales and exports

Steps in this chapter (17)

17 steps, each with a screenshot · Chapter 7 of 20

Sales run from the quote to the cash: quote, sales order, invoice, receipt, and a credit note if something goes wrong. Export sales are invoiced in the customer's currency and are zero-rated for VAT; the naira value is worked out at the rate on the invoice date, and the difference when the money arrives is a realised exchange gain or loss.

Tobi Akinola, export sales executive, sells W320 cashew kernels to Rotterdam Nut Traders in euros. Local sales of by-products, such as cashew shells to a briquette maker, carry 7.5% VAT.

7.1 A local sale with VAT

Screenshot: Sales → New invoice: cashew shells to Zaria GreenFuel Briquettes
Figure 7.1 — Sales → New invoice: cashew shells to Zaria GreenFuel Briquettes

Why

Choosing the item (2) fills in its description, price, income account and VAT code: by-product sales in Nigeria are standard-rated (3). 30 tonnes at ₦45,000 is ₦1,350,000 plus ₦101,250 VAT (4). The stock leaves the warehouse chosen on the invoice.

Who

Sales (Approve level) or accountant.

What to do

  1. Click New invoice. Choose the customer (1); the currency and terms come from the contact.
  2. Add the item (2), the quantity and the tracking. Check the VAT code (3) and the totals (4).
  3. Click Save and approve and post (5). Save draft keeps it for later.

Back to top ↑

7.2 The posted invoice

Screenshot: INV-00001
Figure 7.2 — INV-00001

Why

Posting gives the invoice its number (1) — numbers are allocated in sequence with no gaps — and posts the sale, the VAT and the cost of the stock sold. From here you can record the payment (2), raise a credit note (3) or print it (4).

Who

Sales.

What to do

  1. Click Print / PDF (4) and send the invoice to the customer.

Back to top ↑

7.3 A quote in euros

Screenshot: Sales → New quote: Rotterdam Nut Traders
Figure 7.3 — Sales → New quote: Rotterdam Nut Traders

Why

The customer's currency (1) and the EUR price list fill the price: 8 tonnes of W320 at EUR 6,900 (2). Exports are zero-rated (3). The terms (4) are printed on the quote.

Who

Sales.

What to do

  1. Click New quote, choose the customer and the date it is valid until, add the item and quantity.
  2. Check the price (2) — a note below it shows which price list it came from — and the VAT code (3). Type the terms (4).
  3. Click Save and mark as sent.

Back to top ↑

7.4 Send the quote

Screenshot: QU-00001, sent
Figure 7.4 — QU-00001, sent

Why

Save and mark as sent gives the quote its number (1) and the status Sent. Print it or save it as PDF (2) and send it to the customer. Until the customer answers, the quote can still be edited, and it appears in the Open quotes report.

Who

Sales.

What to do

  1. Click Print / PDF (2).

Back to top ↑

7.5 The customer accepts: convert the quote

Screenshot: QU-00001: Mark accepted, then Convert to sales order
Figure 7.5 — QU-00001: Mark accepted, then Convert to sales order

Why

On 9 February Rotterdam Nut Traders accepted the quote with its purchase order 4500-2261. Recording the acceptance keeps the quote's history; converting it copies the customer, currency, items, prices and terms into a new sales order linked to the quote, so nothing is typed twice. A quote can also be converted straight to an invoice, or marked declined.

Who

Sales.

What to do

  1. Open the quote and click Mark accepted (1).
  2. Click Convert to sales order (2). (Convert to invoice (3) skips the order, for goods sent at once.)
  3. The new sales order opens for editing: add the customer's order number as the reference, the delivery date and the warehouse, then click Save and confirm order.

Back to top ↑

7.6 The sales order

Screenshot: SO-00001: 8 tonnes for Rotterdam, confirmed
Figure 7.6 — SO-00001: 8 tonnes for Rotterdam, confirmed

Why

A confirmed sales order (1) reserves the stock for the customer so that it is not sold twice, and tracks what has been invoiced (2). It is linked to the quote it came from. The credit limit is checked when the order is confirmed. Orders that did not start from a quote are entered with New sales order.

Who

Sales.

What to do

  1. When the goods are shipped, click Create invoice (3).

Back to top ↑

7.7 Stock reserved for the order

Screenshot: Reports → Stock reservations
Figure 7.7 — Reports → Stock reservations

Why

The report (1) shows the stock held for each open sales order. With reservations set to Warn, BookTrove warns if reserved stock is about to be used for another sale.

Who

Sales and inventory.

Back to top ↑

7.8 The export invoice in euros

Screenshot: Invoice from the sales order: EUR, zero-rated, from the Apapa warehouse
Figure 7.8 — Invoice from the sales order: EUR, zero-rated, from the Apapa warehouse

Why

The invoice is in euros (1). The rate to naira (2) comes from the rates on file for the invoice date (here the CBN rate, ₦1,733.69); type a rate only to use a different one. The kernels were moved to the Apapa export warehouse for shipping (3). The VAT code is VAT0 (4). The shipping details go in the notes (5).

Who

Sales.

What to do

  1. On the sales order click Create invoice. Check the date, due date, warehouse and quantity shipped.
  2. Type the bill of lading, container and lot details in the notes (5), and click Save and approve and post.

Back to top ↑

7.9 The posted export invoice

Screenshot: INV-00002: EUR 55,200 at ₦1,733.69
Figure 7.9 — INV-00002: EUR 55,200 at ₦1,733.69

Why

The invoice shows the currency and rate (1) and is linked to the sales order under Related documents (2). In the ledger it is ₦95,699,688.00 of export sales, and the customer owes EUR 55,200.

Who

Sales and accountant.

Back to top ↑

7.10 The printed invoice

Screenshot: Print / PDF: the tax invoice
Figure 7.10 — Print / PDF: the tax invoice

Why

The printed invoice carries the company's details, TIN, the customer, the lines, VAT, totals in the invoice currency, the terms and the bank details from the invoice footer. Once e-invoicing is on, the NRS reference (IRN) and QR code are printed too.

Who

Sales.

What to do

  1. Click Print / save as PDF.

Back to top ↑

7.11 A credit note for a quality claim

Screenshot: Credit note from the invoice: 0.2 tonne of broken kernels
Figure 7.11 — Credit note from the invoice: 0.2 tonne of broken kernels

Why

Rotterdam found 0.2 tonne of broken kernels (1). A credit note reduces what the customer owes by EUR 1,380 (3). The goods were not returned, so Restock is unticked (2) and stock is not changed.

Who

Sales (Approve level).

What to do

  1. On the invoice click Credit note. Change the quantity or price to the amount credited (1).
  2. Tick Show lot, restock and landed-cost columns and untick Restock (2) if the goods are not coming back.
  3. Explain the reason in the notes and click Save and approve and post.

Back to top ↑

7.12 Apply the credit to the invoice

Screenshot: Apply to an invoice
Figure 7.12 — Apply to an invoice

Why

Applying the credit note to the invoice (1) (2) leaves EUR 53,820 to collect, and keeps the customer's statement and aging right.

Who

Sales (Approve level) or accountant.

What to do

  1. On the credit note click Apply to an invoice, choose the invoice and amount, and click Apply.

Back to top ↑

7.13 Receive dollars into the domiciliary account

Screenshot: Sales → Receive payment: Mumbai Spice Importers
Figure 7.13 — Sales → Receive payment: Mumbai Spice Importers

Why

Choosing the USD domiciliary account (1) sets the currency (2). Leave the rate blank (3) to use the rate for the receipt date. The invoice was carried at ₦1,455 to the dollar; the dollars arrived on 21 January at ₦1,467.51, so BookTrove posts a realised exchange gain of ₦825,660.00.

Who

Accountant or bookkeeper.

What to do

  1. Click Receive payment, choose the customer, the date the money arrived and the bank account (1).
  2. Allocate the amount to the invoice (4) — click Full for the whole balance.
  3. Add the bank's reference and click Save receipt (5).

Back to top ↑

7.14 The receipt

Screenshot: The posted receipt
Figure 7.14 — The posted receipt

Why

The receipt shows the amount received in dollars and the rate (1). View journal (2) shows the bank, the receivable at its booked rate and the exchange difference.

Who

Accountant.

Back to top ↑

7.15 E-invoicing with the NRS

Screenshot: Settings → E-invoicing (NRS)
Figure 7.15 — Settings → E-invoicing (NRS)

Why

BookTrove connects to the Nigeria Revenue Service e-invoicing service (the Merchant Buyer Solution). Once switched on (1), every invoice and credit note is validated and signed by NRS when it posts, and gets an invoice reference number (IRN) and a QR code. Each company enters its own details from its NRS dashboard: the business ID (3), service ID, API key and secret (4), and the cryptographic keys file (5). Start in the sandbox (2) and test the connection before production. Signed invoices cannot be voided — correct them with a credit note. Savannah Harvest is waiting for its NRS keys, so e-invoicing is still switched off in the illustration.

Who

Owner or administrator (full settings access).

What to do

  1. Register the company on the NRS e-invoicing portal and download the keys.
  2. Enter the details, choose Sandbox, save and click Test connection.
  3. Fill in the supplier details and the default HS or ISIC codes and unit of measure, then switch e-invoicing on.

Back to top ↑

7.16 The e-invoicing queue

Screenshot: E-invoicing (NRS) → Not queued
Figure 7.16 — E-invoicing (NRS) → Not queued

Why

The page lists invoices and credit notes waiting to be sent, those needing attention, those signed and those not yet queued (1). Anything NRS rejects stays here to be fixed and sent again; failures are retried automatically.

Who

Sales or tax.

What to do

  1. Click Check payload (2) to see what would be sent before switching on.

Back to top ↑

7.17 Check what would be sent

Screenshot: What is sent to NRS — INV-00002
Figure 7.17 — What is sent to NRS — INV-00002

Why

The check lists anything to fix before sending (1) — here, the NRS business and service IDs that have not been entered yet — and shows the data that would be sent.

Who

Sales or tax.

What to do

  1. Fix the problems listed, then send.

Back to top ↑