Data Import Hub: Ingesting Your Financial Data

The Data Import Hub is where the magic happens. While the interface is incredibly simple, the logic running behind the scenes does the heavy lifting of reading, normalizing, and combining the wildly different spreadsheet formats from KDP, ACX, IngramSpark, and other vendors into your master database.

1. Batch Importing Royalties

The Goal: Upload your monthly or historical sales spreadsheets into Imprint Core.

Click the top Batch Import Royalties button to open your file explorer.

• Mix and Match: You do not have to upload files one by one, nor do you have to sort them by vendor! You can highlight a dozen different spreadsheets from KDP, ACX, and Draft2Digital spanning several different months, and Imprint will process them all simultaneously.

⚡ Pro-Tip: Upload Limits While the engine is powerful enough to handle massive batch imports, we highly recommend keeping your uploads to a maximum of one year's worth of data at a time to ensure maximum stability and to make it easier to audit your records as you build your database.

2. Batch Importing Payment Files (FX Updates)

The Goal: Automatically calculate perfectly accurate Foreign Exchange (FX) rates for international sales.

Because international currency values fluctuate constantly, calculating exact royalties on foreign sales can be a nightmare. Imprint Core solves this using the KDP Payments Spreadsheet (downloadable from your Amazon KDP dashboard).

1. Click Batch Import Payment Files (FX Update) and select your KDP Payments spreadsheets.

2. Amazon is uniquely detailed in providing exact exchange rates for specific payment periods. Imprint Core automatically extracts these historical FX rates and cleanly assigns them to all transactions (even non-Amazon ones) for that matching time period!

Alternative: If you do not use KDP or prefer not to use this automated FX extraction, you can simply manually define your default currency exchange rates over in the Settings tab.

3. Import History & Rollbacks

The Goal: Audit your previous uploads and undo any mistakes.

The Import History table at the bottom of the screen maintains a permanent log of every file you have ever uploaded, showing the filename, the date it was imported, the number of records it contained, and the data type.

Making a mistake is easily fixable: If you accidentally upload the wrong spreadsheet or upload the same file twice, simply highlight the file in the Import History table and click the red Rollback Selected Import button. Imprint will instantly scrub those specific records from your database.

🚨 WARNING: The Rollback Lock

To protect the integrity of your accounting, you cannot roll back an import if a Statement has already been produced and marked as "Paid" for that period. Once a statement is finalized in the Statement Engine, the data backing it is permanently locked into the ledger.