The Transactions to Date report gives you a detailed overview of all of your invoice funding transactions with FundThrough. It has all the information you need to reconcile your accounting yourself, or send to your finance department or external accountant. To determine the total deposited in your bank account on a given day, add up all the transactions, as transactions aren’t correlated to deposit amount. Also, please allow up to one business day for all transactions to be reflected in the report.
Watch the video to see how to access the report step-by-step, or follow these instructions:
Login to your account. Click the 3 lines in the upper left-hand corner
Click Reports
Under Transactions to Date, click Generate CSV. (Note: if you still see a spinning progress wheel after a few minutes, refresh the entire page. You should then see that the report has been refreshed.)
Click the Download button to get a .csv file
Note: You can download this report to your mobile device so that you can easily email it, even if you’re away from your desk.
Here’s an example of what the report looks like.
Here are the definitions for every column:
transaction_date: | The date the transaction was recorded in our database |
transaction_id | A unique identifier used to identify/define the transaction for FundThrough internally |
transaction_description: | A brief text description of the transaction, including the transaction type (e.g., Advance, Repayment, Remittance, Wire), the invoice number and the payment reference number |
currency: | The transaction's currency |
customer_paid: | The amount your customer paid to Fundthrough against the original advance on a particular invoice |
principal_balance: | The sum of outstanding money still owed to date (including fees) in aggregate |
advance_repay | The net dollar amount advanced or repaid |
fees: | The transaction fees charged |
held_in_reserve: | The dollar amount held in reserve and owed to you. The amounts in this column are usually negative on non-funded payments from your customer that are sent to you. On remittance, we release the reserve, which equals cash to you in the next column.
For example, in row 17 for invoice 56678, there is the $3,200 payment from the customer and held in reserve is -$3,200, so cash to you equals zero. Then on the next row, the remittance has reserves of +$3,200 and cash to you +$3,200. If the invoice had been funded instead, there would be a value in column G, advance repay.
However, it is possible to have an amount in both advance repay and held in reserve. If an invoice is funded at less than 100%, then the customer payment amount minus the advance repay amount equals the amount that would appear in the held in reserve column.
|
cash_to_you: | The final dollar amount sent to you. (The amount advanced less the fees associated in addition to any money held in reserve). To match it with the amount that lands in your bank account, please total all the line items for a given date. |