Setup Custom CSV Download Formats
Acxite offers several ready-made formats for downloading your bank transaction data. However, if you require a specific layout, you can design a custom CSV Excel format within Acxite to download your statement data, ensuring it perfectly matches your business’s financial reporting and analysis needs. This feature is an integral part of Acxite’s intelligent document processing, allowing you to tailor how your extracted bank statement information is presented.
Create your custom format
To create your own CSV download format in Acxite, follow these steps:
Step 1 – Navigate to the Bank Statement page using the business menu.
Step 2 – Click on the Formats option from the top right corner.
Here you will find a list of all available download formats in Acxite.
Step 3 – Click on the Add Format button.
Step 4 – Start making your customised download format by completing the format details and mapping each available field to a column of your choice.
Step 5 – Change the sequence of columns by dragging the column title.
Step 6 – Click the Download Sample button to view a sample CSV file.
Step 7 – Click the Save button.
Your custom CSV format will be saved and marked as a favourite, and you can download your statement transaction’s data in the new format.
Available customisations
When preparing a custom format, you can perform the following customisations to your data:
Format details
You can provide a name for your custom format. It is better to use short and clear names so that your team members can quickly understand the utility of the custom format.
You can also provide a short description of the format further to explain the expected usage of the custom format.
Column titles
This setting allows you to include or exclude column headers in the output CSV.
Account details
Here you can add account information like bank name, account number, opening balance, closing balance, or any other account-related information to the CSV.
Transaction date
Here you can provide a column title for the transactions’ date and specify the format in which the date should appear. Currently, Acxite supports the following date formats:
- DD-MM-YYYY
- MM-DD-YYYY
- YYYY-MM-DD
- DD-MMM-YYYY
Description
You can specify whether you want the extracted description column in the output CSV. You can also specify the column title for the description column.
Sometimes due to special characters or new lines, the descriptions data corrupts the CSV file. Therefore, Acxite provides two additional settings: Export description in a single line and Remove special characters from descriptions.
Sub account reference
You can specify if the sub-accounts identified in a statement should also be included in the CSV. If yes, you need to specify the column title for the sub-account reference.
Reference
Here you specify if the transaction Reference identified in a statement should also be included in the CSV. If yes, you should specify the column title.
You also have the option to merge the reference column into the description column.
Transaction amount
You can specify if the transaction amounts should appear in a single column or be broken into double columns.
If enabled, the transaction amounts will be in two columns (Money In & Money Out), both as positive values.
If disabled, the transaction amounts will be in the same column, with money in as a positive value and money out as a negative value.
Memo amounts
You can specify if the memo amounts identified in a statement should also be included in the CSV. If yes, you should also specify the column title for the Memo Amounts.
Balance
You can specify if the balance identified in a statement should also be included in the CSV. If yes, also specify the column title for balance.
Sequence
You can specify if the sequence identified in a statement should also be included in the CSV. If yes, then also specify the column title for the sequence column.
Frequently asked questions
Q: What is a custom CSV format in Acxite, and why would I need it?
A: A custom CSV format in Acxite allows you to create and download your bank statement data in a format that best suits your accounting needs, directly within the Acxite platform.
Q: How can I download data in my custom CSV format in Acxite?
A: After creating and saving your custom CSV format in Acxite, you can download your statement transaction data in the new format from the Bank Statement page.
Q: What if I need a custom format that cannot be made with the above options?
A: If you need a custom format that’s impossible with the current options, please contact our support team, and we’ll assist you further.
Q: What date formats does Acxite support for the transaction date?
A: Acxite supports four date formats for the transaction date: DD-MM-YYYY, MM-DD-YYYY, YYYY-MM-DD, and DD-MM-YYYY.
Q: How can I avoid corruption of the CSV file due to special characters or new lines in the description data?
A: Acxite provides settings to “Export description in a single line” and “Remove special characters from descriptions” to avoid CSV file corruption.
Q: How can I specify if the transaction amounts should appear in a single column or be broken into double columns?
A: In the “Transaction Amount” setting, you can specify if you want amounts in a single column (money in as positive, money out as negative) or two columns (Money In & Money Out as positive values).