With Float’s new CSV builder, you can create custom templates for exporting transactions to any accounting system. Here’s what you can do with Float’s CSV templates:
- Create multiple templates for exporting transactions
- Upload a template to start with OR create a new template from scratch
- Map columns to available fields from Float
- Add custom fields
- Re-order columns
- Rename columns
Related: How To Export Transactions in CSV
Creating CSV Export Templates
Navigate to Settings > Accounting > CSV Export
- Click “Create a new Template”
- Give it a name, this will be displayed when you export transactions.
- Choose the Accounting System this template will be used for.
- An optional but recommended step is to upload a CSV template from your accounting system to save time creating fields.
- This will create your template with all the columns in the CSV.
- Click Map Fields to get started with your template
Note 💡: Available fields from Float are listed on the left. On the right, are the columns and column names that will be exported in your CSV file.
-
Add Columns to your template by clicking the “Add Columns” button.
- Available fields are organized by Category to help you find them more easily. You can also search by Categories or Fields.
- You can change fields by clicking on the ‘Float’ button next to the Field name.
- Change the order of fields by dragging and dropping.
- Where available, change the format of the field by clicking the Format Settings button.
- Rename the column on the right-hand side, this is the name of the field for export.
- You can also add a column to your template by inserting it between other columns, clicking “Insert Column”
- When you’ve added all the appropriate fields, you can hit “Save &Preview” to get an idea of how the file will look.
- Click Save to save your template.
Exporting using a custom template?
While logged in to your admin portal, navigate to 'Accounting' in the left sidebar
-
Choose “Transaction Export”, then click on the ‘Ready to Export’ stage
- Note 💡: Ensure the transactions you’d like to export are in the ‘Ready to Export’ stage
- Select the transactions that you would like to export
- Hit the 'Export CSV' button
- Choose the template you’d like to use for exporting your transactions.
- You can choose to simply download the CSV, or export and move the transaction to ‘Export History'
FAQ
-
I already have a custom CSV, can I keep using it?
- The custom CSV you use with Float will still be available, in addition to any new templates you create. When you go to export, you will have the option to use Float’s “Standard CSV”, your current “Custom CSV”, or any new templates you’ve created.
- The custom CSV you use with Float will still be available, in addition to any new templates you create. When you go to export, you will have the option to use Float’s “Standard CSV”, your current “Custom CSV”, or any new templates you’ve created.
-
How can I request new fields or functionality for the CSV Builder?
- Our product team would love to hear your feedback! Share your feedback here!
- Our product team would love to hear your feedback! Share your feedback here!
-
I exported transactions with the customer CSV but the 'Float Transaction ID' field is empty. How do I fix this?
- If you've exported and see that the 'Float Transaction ID' column is empty, please delete and read the field in the CSV builder and export again. The field may not have saved correctly to the template the first time around.
If you have any further questions, please reach out to support@floatcard.com!
Comments
0 comments
Please sign in to leave a comment.