In this article, we explain the discontinuation of Sage50 sync support, outline the challenges and reasons behind this decision, and provide detailed instructions for transitioning to manual data uploads.
TABLE OF CONTENTS
- Why are we discontinuing support of Sage50?
- What does this mean for our customers?
- Recommended process for manual data upload If synchronisation has not been set up
- Recommended process for manual data upload If synchronisation has been set up
Why are we discontinuing support of Sage50?
- Challenges: Maintaining the outdated system has become increasingly difficult and time-consuming.
- Compatibility Issues: Different versions and APIs of on-premise solutions are harder to address.
- Resource Focus: Prioritising our cloud sync offerings for a more seamless and reliable experience.
What does this mean for our customers?
- Current Support: Extends up to version 29; no new versions will be supported.
- Recommendation: Transition to manual data uploads. Switching to manual uploads should not cause a loss of functionality. Manual uploads will be faster and offer a smoother experience.
Recommended process for manual data upload If synchronisation has not been set up
Year 1:
- Run Reports: Run a full nominal activity report for the current and prior year from Sage50.
- Upload Data to Silverfin: Upload the nominal ledger to Silverfin. You can upload all the data simultaneously for multiple periods in a single action. Here are a few important reminders when performing the upload:
- ensure all columns have headers.
- avoid blank rows in the data.
- do not separate thousands with commas.
- use ‘date format’ for dates in Excel.
Importing the full nominal ledger will in essence replicate the same data that you had previously with the sync.
The following columns are essential in order to successfully add the data (but you can import as much information as you feel necessary):
- Account Code: account code for the particular line item.
- Account Name: name associated with the ledger code.
- Value: select value (balance) or both debit and credit columns (sum must equal zero).
- Booking Date and / or Period: associate bookings with a chosen period.
Year 2
- Create a new empty period: Click add new period on the client overview page. In the first step Upload data choose create an empty period.
- If Nominal report includes the opening balance, proceed to step 6. If Nominal report from Sage only includes transactions from the start of the year, then continue to step 3.
- Navigate to Edit Client and then navigate to Periods.
- Tick Opening balances to roll forward the prior year closing balances to the current year.
- Tick Retained earnings to move the P&L balances from the prior year into the retained earnings account in the current year. Don’t forget to select the retained earnings account underneath.
- Replace bookkeeping data with nominal report from Sage50.
Recommended process for manual data upload If synchronisation has been set up
Current Year
- Disconnect Sync: click Edit Client, then navigate to Syncs and click disconnect.
- Check Nominal Report: If the nominal report includes the opening balance, proceed to step 6. If the nominal report only includes transactions from the start of the year, continue to step 3.
- Navigate to Edit Client and then navigate to Periods.
- Tick Opening balances to roll forward the prior year closing balances to the current year.
- Tick Retained earnings to move the P&L balances from the prior year into the retained earnings account in the current year. Don’t forget to select the retained earnings account underneath.
- Replace bookkeeping data with nominal report from Sage50.
We recommend to manually check that opening balances agree between the prior period in Silverfin but you can be confident that the prior year work that was completed in Silverfin will not have been changed.
We recognize that this change might be difficult, but we are confident it will enhance your user experience. If you have any questions or need support, please contact your customer service manager or our support.