Sage Desktop

This help article shows you how to obtain and format the manual upload file for a Sage desktop job.


  1. How to run the report required for the manual upload
  2. How to format the report for importing
  3. How to run the brought forward Sage TB
  4. How to import the trial balance as a journal to Silverfin

*Important*

It is important when doing a Sage job that you use the brought forward balances per Sage rather than using the roll forward function on Silverfin.

This is so you can identify if any client back postings have occurred as it will throw up a difference in retained earnings.


NOTE: Training on how to restore a sage back up and how to access and use sage will be given within your local office.


  1. How to run the nominal ledger report (see video here - 40sec)

Select: Nominal codes (left hand side), Reports (top right), Nominal activity (left hand side), Nominal Activity - Excluding No Transactions

Criteria: Nominal Code - leave line as blank and 99999999, Transaction Date - the period of accounts you are doing, Transaction No - leave line as 1 and 99999999


Export to Excel: Select Data to Excel

  1. How to format the report for importing (see video here - 1min30)

-Open out all cells (click top left corner to highlight, then double click line between A & B)

-Delete row 1

-Delete columns A, D, F, M (if departments are not used), O, P & Q

-Rename columns A = Nominal code, B = Nominal Name, C = Amount, D = Transaction No., E = Transaction Type, F = Date, G = Relation, H = Reference, I = Details, J = VAT code

-Highlight the "Amount" column and change to accounting format

-Check that the "Amount" column comes to zero - highlight column and check sum at bottom right corner of screen

-Save the file somewhere on your computer but also save to Sharepoint and Silverfin documents. Suggested name "TEST001 2023 manual import file".


  1. How to run the Sage brought forward TB (see video here - 30sec)

-Ensure Sage is in the correct year eg for year end 31/03/2022 the start month at the bottom right corner of Sage should be April 2021.

Select: Nominal codes (left hand side), Trial balance (top), Preview, Period = Brought forward (scroll to top), Ok

-Export to Excel: Select Report to Excel


-Save as TEST001 Sage Bfwd TB 2022


  1. How to format the TB and importing as a journal to Silverfin (see video here - 2min)

The journal import function can be helpful if the TB is large as it will save you typing it up manually.

-Download the journal import template from Silverfin (Adjustments, Drop down "Download/Upload" and select "Upload", Select "Download example".

-category = external

-account_number = leave blank

-original_account_number = copy and paste N/C column from Sage TB

-account_name = copy and paste Name column from Sage TB

-description = being b/fwd Sage Tb

-value_debit & value_credit = cope and paste Debit and Credit column from Sage TB

-tags = leave blank

-highlight sheet and covert format to "Text"


-Save as TEST001 Sage Bfwd TB 2022 journal import

-Upload the journal to Silverfin (Adjustments, Drop down "Download/Upload" and select "Upload")

-Drag and drop the formatted import file




NOTE: If there is anything in this help article that needs updated please get in touch with one of the Silverfin Experts.

Related Articles