How to import invoices

Upload a CSV/XLSX file with your invoices to Banktrack

To import collections and payments into Banktrack, you can use the template we provide or adjust the format of your file to ensure it works correctly.

Downloadable template

Download our template to make sure your CSV file meets the required formats: https://docs.google.com/spreadsheets/d/16AJR9se-eLPrG3uU3Ty6a_e7fQJjJTTiUb9pscevkNE/edit?gid=0#gid=0

Accepted column formats

The columns to import must follow this format:

ℹ️ All fields are optional.

• Identifier: text or number used internally to avoid duplicates.

• Invoice type: specific values. Must match exactly:

  • cash_in: represents a receivable.

  • cash_out: represents a payment.

• Invoice number: text and/or number identifying an invoice.

• Description: text describing the invoice.

• Issue date: format YYYY-MM-DD (Example: 2024-03-09)

• Due date: format YYYY-MM-DD (Example: 2024-03-09)

• Payment date: format YYYY-MM-DD (Example: 2024-03-09)

• Amount: number with no thousand separator and a comma as decimal separator. (Example: 8500,22)

• Taxes: number with no thousand separator and a comma as decimal separator. (Example: 8500,22)

• Currency: specific values. Must match exactly as listed. For example: Euro = EUR. British pound = GBP

• Reconciled: specific values. Must match exactly:

  • TRUE: If the invoice is matched to a transaction.

  • FALSE: If the invoice is not matched to a transaction.

Examples of accepted and not accepted formats

• Date format: Accepted: 2024-03-09 Not accepted: 9/3/2024 or 09/03/2024 or 09-03-2024 or 9-3-2024

• Amount format: Accepted: 8500,22 Not accepted: 8.500,22 or 8500.22

If you have any questions about importing receivables and payments, you can contact us through the chat in the lower right corner of the screen.