How to Export and Import Finance Data via CSV

Intro

Managing your club’s finances means regularly moving data in and out of BallersBook. Whether you need to run a billing report for your accountant or automatically import transaction records from an advertising platform, CSV is the most common format. This guide covers two workflows: exporting finance records (invoices, payments) to CSV, and importing transactions using the built-in smart detection tool with column mapping presets for Facebook Ads, Alibaba Orders, and custom templates.

⚠️ Note: The import automation features described here rely on functionality that is not yet fully documented. Sections marked with TODO indicate gaps. Refer to the official BallersBook release notes for the latest updates.

Prerequisites

• A BallersBook account with the Admin or Finance Manager role (requires the manage_finance permission).
• At least one season configured in Finance Seasons (to link invoices and payments).
• If importing, have your CSV file ready (for Facebook Ads, Alibaba Orders, or your own template).

Step-by-step

Exporting Finance Data to CSV

1. From the sidebar, click Finance → Invoices (or Payments).
2. Use the filters (season, date range, group) to narrow down the records you want to export.
3. Click the Export button located above the table (or at the top-right of the list).
4. In the export modal, choose CSV as the format. Optionally, select which columns to include (e.g., Invoice Number, Player Name, Amount, Status).
5. Click Download to save the file. The exported CSV will include all visible records from your filtered view.

Importing Transactions Using Smart Auto-Detection

The Import tool can automatically detect the structure of CSV files from common sources and map columns to BallersBook fields. Currently supported presets include:

• Facebook Ads - transaction reports from Meta Ads Manager.
• Alibaba Orders - order summary exports from Alibaba.
• Custom Template - any standard CSV file you define with a custom column map.

1. Go to Finance → Import (the button or tab may be labeled Import CSV). If you do not see it, ensure your role includes manage_finance and that the feature is enabled for your club.
2. Click Choose File and select your CSV file from your computer.
3. In the Source Type dropdown, choose one of:

• Facebook Ads
• Alibaba Orders
• Custom Template

4. The tool will automatically scan the first few rows and prefill the column mapping presets. For example:

• For Facebook Ads, the tool expects columns like Date, Amount Spent, Impressions, Clicks, and maps them to BallersBook fields (e.g., transaction_date, amount, description).
• For Alibaba Orders, columns like Order ID, Total, Status are mapped accordingly.
• For Custom Template, you will need to manually assign each column to a BallersBook field using the dropdown selectors.

5. Review the mapping. You can override any preset by changing the field assignment in the Map Columns section.
6. Click Preview Import to see a sample of how the first 5 rows will be inserted.
7. If everything looks correct, click Confirm Import. The records will be added to the selected season’s transaction log (invoices or payments, depending on the template).

💡 Tip: If your CSV has headers that exactly match the preset column names, the auto-detection will work without any manual adjustments.

Tips & Pitfalls

• Always preview before confirming. A wrong mapping can create duplicate or incorrect financial entries.
• Export before importing. If you are unsure about the data structure, export a sample CSV of your current finance records first to see the expected column headers.
• Custom template column names are case-sensitive. Use the exact field labels shown in the mapping interface (e.g., transaction_date, not Transaction Date).
• Large files (over 10,000 rows) may take a few seconds to process. The system will show a progress bar.
• Facebook Ads exports often include multiple currencies. Ensure your club’s default currency is set under Club Settings before importing.
• If you do not see the Import option, verify that your role includes the manage_finance permission (check with your super admin).

Summary

You can now export invoices and payments as CSV files for external reporting, and import transaction data from Facebook Ads, Alibaba Orders, or custom CSV templates using the smart auto-detection tool. Start by filtering your finance records, export to CSV, or navigate to the Import section to map columns and bring in external data. For the latest updates on import presets and column mapping, watch the BallersBook changelog.