Help center
Invoicing & VAT

Import my sales invoiced in another tool

1 min read Sales > Customer invoices > Import sales
Download as PDF

You invoice in another tool: import your sales, Comptia posts the entries.

How to

  1. In Sales · customers, click « Import sales ».
  2. Click « Download the template » and fill it in.
  3. Drop the file in « Sales file » and pick the options.
  4. Click « Check the file ». If a « Recommendation » shows, check the fixed rows and click « Approve ».
  5. Click « Import ».
Learn more

If your invoices are issued by another tool (till, invoicing software, spreadsheet), « Import sales » takes their list and posts the entries (411 debit, 70x and output VAT 443 credit). The file is checked first: nothing is written until you click « Import ».

The file

« Download the template » gives the Excel file (or « or as CSV ») with the columns Date, Invoice number, Customer, Amount excl. VAT, VAT rate, VAT amount, Amount incl. VAT, Payment status, and optional columns (Customer code, Customer tax ID, Payment date, Due date, Revenue account, Description). The « Notes » sheet explains each column. Two of excl. VAT, rate, VAT and incl. VAT are enough; when more are given, they must agree. Rows with the same number and the same customer make one invoice. If your headers differ, the « Column mapping » screen opens. If your « VAT » column holds the VAT amount rather than the rate (net 100000, VAT 18000, total 118000), the import offers « VAT column = amount, rate derived »: approve it, the rate is computed and the file's value stays in the history.

One invoice per sale, or one entry per day or month

« One customer invoice per sale » creates each invoice under Sales · customers, with its original number, and its entry. « One sales entry per day » or « per month » posts a single entry per period (one 411 per customer, one credit per revenue account and VAT rate), dated the last sales day of the period, for many small sales.

Paid invoices

« Paid invoices »: « Leave open (bank matching) » keeps the receivable open, settled later when the statement is matched. « Received on » a bank account, or « Received in cash (571) », also posts the receipt at the payment (or invoice) date. Only pick an account if these receipts will not come in through the bank statement, or they would count twice.

The check and duplicates

« Check the file » shows, per invoice, « To import », « Already imported » or « Error » with the reason (unreadable date, inconsistent amounts, closed period, account not in the chart). An invoice already imported (same number, same customer), already entered in Comptia or validated in the inbox is never taken again. Unknown customers are created on import. Invoices with errors are skipped: fix the file and import it again.

FNE and MeCEF

These invoices were issued, and certified where needed, by your invoicing tool. Comptia does not certify them a second time and does not produce a PDF of them: they show « Issued outside Comptia ». Credit notes (negative amounts) are entered in Comptia.

One sale at a time

In the inbox, pick « Sales (invoices issued) » before dropping your invoices: they are read as sales (411 and 70x). In Bank, on money received with no invoice, « Create the sale » records the sale and its receipt, and reconciles the line.

Frequently asked questions

I import the same file twice: what happens?

Invoices already imported show « Already imported » and are skipped. Only the new ones are imported.

How do I cancel an imported invoice?

Reverse its sales entry from Journal entries, then cancel the invoice under Sales · customers (or, in per day or per month mode, reverse the sales entry). An invoice imported then cancelled stays « Already imported »: a new import of the same number for this customer is skipped, enter it in Comptia if needed.

A specific question?

The Comptia team is available Monday to Friday, reply within 4 business hours.

Contact support