This article advises on how to set up factoring and report on it within KashFlow. Although our report is titled HSBC factoring it can be used for other factoring services.
Setup
To deal with factoring in KashFlow you should setup a new bank account for use with factoring. Do this by going to
Bank > Add New Account
You only need to worry about three fields here:
- Account Name – Give this account a unique identifying name, i.e. “Factoring Account”.
- Starting Date – the starting date should be before the first transaction, i.e. “01/01/1970”
- Starting Balance – This should be “0.00”
When ready, click Update.
Recording Sales & Payments
When recording payments against Invoices, under the payment details section of the Invoice use the Bank Account drop down menu to select your new factoring account. Payments will now be recorded as going into this account.
When you receive funds from the factoring company you should Transfer Money from that account to your main account. To do this, go to
Bank > Transfer Money
On this screen:
- Date – Enter the date that the amount was transferred from the factoring company to yourself
- Amount – Enter in the amount withdrawn or transferred
- From – This will be the factoring account
- To – This will be your business account where you received the money
- Comment – to make this easy to reconcile you can enter in something like ‘Factoring Payment January 2013′
When ready, click Create Transfer.
To record fees for the factoring, go to
Bank > View/Add Transactions (of the factoring account)
Use the add a transaction fields at the top of the page to add a new Money Out Transaction with the type of bank charge for the amount of the fees.
Reporting
If you use HSBC for Invoice Factoring you can generate the required files direct from within KashFlow.
You’ll first need to enter your customers client numbers by going to
Settings > Custom Customer Fields
Name the first field Client Number and click Update. You will now be able to go to
Customers > Click on the Customer > Other Info (or CIS and Other Info) > Enter in the customers client number
You can now run the HSBC factoring report by going to
Reports > Income Reports > HSBC Factoring.
Using the fields here:
- Client Number – This is your client number for HSBC
- Password – This is your password for HSBC Factoring Service
- Start Date
- End Date
When ready, click Create Text File. This will download the required file to your computer for submission to HSBC.