If you are using a GL manual upload, and you need to roll forward your opening balances there are 2 things you need to do!


1. Ensure the roll-forward 'arrow' is selected in the 'Edit Client' screen

To do this, navigate to the 'Client Overview' and in the top right is 'Edit Client.' On the top right you will see the ledger dates applied to that client. For the year that you want to transfer the opening balance, hit the grey pencil:

You will see a light grey arrow, and if you hover over this, it tells you that this will transfer the opening balance.

Click on this arrow to confirm that you want to transfer the opening balance from the prior period and hit the green tick.

You might note that you are also able to change the dates of your manual uploads- you are able to change the dates of manual uploads yourselves, but use this with caution as it can often confuse the ledgers, so it's best to reach out to Silverfin support for help with this!


2. To transfer the P&L to Retained Earnings, you need to add a line into your manual upload, and assign this to 'P&L bought forward.'

Add an extra line for prior year profit to the data in your manual upload for the new period, and then upload the spreadsheet as normal, mapping the new line to profit and loss b/fwd- code 310100.

Silverfin will say the data does not balance when you try to add the upload, but because Silverfin clears down the P&L of the prior year, this will balance out!

Note: Watch out for Dividends- it depends whether you map this as an equity or expense,

  • If your Dividends are mapped to an Equity code (310101), the balance in this code will also be pulled forward in to your current year. In order to avoid this please insert an additional line into your manual upload to reverse this balance out.

We are working on a solution to automate this in the future, but in the meantime, this is what is required to transfer your P&L to Retained Earnings.