Sum-It

This help article shows you how to obtain and format the manual upload file for a Sum-It job.


  • How to restore a Sum-It back up
  • How to run reports from Sum-it
  • Suggested reports required
  • How to export the reports
  • How to format the Silverfin manual import file

Note: Please note that not everyone has Sum-IT on their computer. You will only be able to restore back up and run reports if you have the programme on your computer or have access to a computer that has it. See below list of offices/people with access. Alternatively you could send instructions to your client and ask them to send you the report.


  • Forfar - everyone in Forfar has access as it is on a local computer

How to restore back-up;

  1. The back up file should be an “.sdz” format
  2. Open programme
  3. Select “Maintenance”

  1. Select “Data Tools”

  1. Select “Transfer In / Out” then select “In” then “Find File” and pick up the back up from where you have saved it.

  1. You should now be able to open the data by double clicking the company name on the home page.

How to run the reports;

  1. Select “View Reports” on the left hand side

  1. Select the reports you require from the list and ensure you pick up the right period from the right hand side

Suggested reports below;

• Audit Trail (Sequential) – csv – this is a good report for using as a nominal ledger import to Silverfin

• Audit Trail (By Nominal) – pdf – this is good for previewing the nominals

• Bank Reconciliation (as at Year End) – pdf

• Debtors / Creditors (as at Year Start) – pdf

• Previous VAT Periods – pdf – need to run report for each separate vat period

• VAT Not Claimed (as at Year End) – pdf – good report to pick up late claims

• Year Start Trial Balance – csv & pdf

• Year End Trial Balance – csv & pdf


How to export the reports;

• Print preview

• Export (top)

• Select pdf/csv etc

• To close click the “X” then click “Abandon” or “Exit” and this will take you back to report screen


How to format the Silverfin nominal ledger import;

  1. Open the “Audit Trail (Sequential) csv file and do “File” and then “Save as” and save it as an excel file and rename it as “Nominal ledger import”
  2. Delete the last two columns (Gross and Paid) and the last row (subtotals)
  3. Insert a column after “Nom” and name it “Nominal Name”
  4. Add a new sheet at the bottom of the file and call it “Trial balance”
  5. Copy and past the year end trial balance file into here
  6. Use a v look up formula in the nominal name column to pull through the nominal name from the trial balance
  7. Apply a filter to the headings and check there are no blanks or N/a for the nominal name
  8. Add a column in between Net and Vat
  9. Name this Credit and rename Net to Debit
  10. Filter the type to pick up all the “S” (sale) transactions
  11. In the Credit column use formula “=“ and pick up the figure in the debit column to move it in to the credit column
  12. Drag formula down to the bottom to apply it to all “s” transactions
  13. Highlight column and select copy and then “Paste Values”
  14. Remove the data from the debit column
  15. Now need to add in the balance sheet movements, these can be calculated by comparing the year start trial balance with the year end trial balance


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