For reconciling a sales ledger for a factoring company
monthly reportFor a company who factors their Sales Ledger to
a Factoring company.
Designed a spreadsheet
where the Sales Ledger transactions for the month are
imported from their accounts package in a very simple
way.
From within the
spreadsheet, this imported data is automatically
organised into various pages of the spreadsheet
depending on the transaction type, being added to
unreconciled transactions from the previous month.
From the Factoring
company statements, the end users mark transactions off
as they are reconciled.
At the end, any
transactions remaining on the Factoring company
statements are added to a page of the spreadsheet.
The spreadsheet then
produces a report which allows the end users to
investigate unreconciled transactions and make the
necessary changes in the new month on their accounts
package.
Finally, the spreadsheet
produces a report in the same format as required by the
Factoring company to send back.
