You may wish to upload transactions in bulk for a few reasons. Perhaps we are not able to connect to your bank account for automatic import, or maybe you want older transactions that the automatic import can't get. Regardless, uploaded transactions will flow into the import feed for quick booking with much less manual data entry.
Additionally, if your bank provides only a limited history of transactions (e.g., the last 90 days), you can manually export older transactions and upload them into REI Hub to ensure your financial data is complete, which this article focuses on.
REI Hub offers three different ways to add transactions:
Link an account to have transactions imported automatically
Add transactions manually one by one
Upload transactions downloaded from your bank or credit card
Almost all financial institutions will allow you to export a transaction history in a file type that REI Hub supports, giving you the data needed for this process.
Preferred file types:
Open Financial Exchange (.ofx)
QuickBooks Web Connect (.qbo)
Quicken Web Connect (.qfx)
Additional file types (which are moved to a template to upload):
Excel (.xlsx)
Comma Separated Values (.csv).
To Upload Transactions
1) Navigate to the import feed and click the 'Upload' button
Navigate to Accounts > Banking.
Open the relevant account by selecting the appropriate option (e.g., "Unbooked" or "View All").
If you're adding these exports to a manual account, make sure it's created first.
2) Click the 'Upload' button
3) Select the appropriate file type (the same as you selected when downloading from your bank)
The .ofx, .qbo, and .qfx file types are preferred. Uploading these file types does not require additional steps.
For .xlsx or .csv files, download the REI Hub template from the platform. Copy and paste your transaction data into the template, ensuring all required fields are filled out correctly. Save the file in the appropriate format before proceeding.
These files are usually found on your bank's website, typically near the section where your monthly statements are located.
Before uploading spreadsheet files, ensure the date ranges are correct, if uploading through Excel that they are properly formatted as per REI Hub's template, and any duplicate transactions are removed to maintain data accuracy and avoid redundancy.
4) Click to add your transaction file and upload the transactions
Click the button "click to add your transaction file."
Drag and drop the file into the upload area.
Select the date range for the transactions you want to upload.
5) View and Book your newly uploaded transactions
Ensuring that historical transactions are uploaded will provide a complete overview of your transaction history in REI Hub and allow for accurate bookkeeping. This process complements ongoing synchronization for future transactions.
Any uploaded transactions that match existing transaction matching rules will be automatically booked.
For all other transactions, click Book to complete the required information and officially add the transaction to your books!
Still have questions? Reach out to our Support Team via email at [email protected] or call us at (888)939-6865.