I have a data that is in a mess from the previous bookkeper/accountant and I need to sort it out. I'd like to clear the slate from the last year end forward.
Is it possible to remove the data up to the year end and put in the opening balances and retain the data from from the year end to date (6 months of information). I understand there is import/export function but I am not sure that is the way forward. I have opening balances but I do need to retain the data that has been posted for this year.
Thanks in advance for your assistance.
Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
Sage Line 50 V10 It's a bit of mess quite frankly
-
brucedenney
- Site Admin
- Posts: 4664
- Joined: 28 Feb 2006, 09:56
- Sage Version: v30 UK/Europe/Africa
At year end, your previous accountant should have taken a backup.
You could just restore that and then post forward from there.
Unfortunately removing data already in Sage would probably not work, the bank rec and vat reconciliation would all get in a mess.
Starting from the year end backup would seem the best option to me.
You could just restore that and then post forward from there.
Unfortunately removing data already in Sage would probably not work, the bank rec and vat reconciliation would all get in a mess.
Starting from the year end backup would seem the best option to me.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
-
brucedenney
- Site Admin
- Posts: 4664
- Joined: 28 Feb 2006, 09:56
- Sage Version: v30 UK/Europe/Africa
The Journals should be in the audit trail, so you can look them up.
Of course the level of detail in them may be scant.
If it were a real problem, then it is possible that we could "alter" the data for you. However this would not be the great solution it sounds.
1/ Invoices already updated to the ledgers will still be updated to the ledgers even though they have been removed so you will have to repost them manually.
2/ We will remove items that have been flagged as having gone on the VAT return and so you will need to control VAT some other way for the next return.
3/ We will break the Bank Reconciliation as reconciled transactions will get removed.
---------------------------------
I guess it depends on how much data you have and how bad it is. I think working forward is generally a better option. If you find problems, reverse them out and re-key them.
Of course the level of detail in them may be scant.
If it were a real problem, then it is possible that we could "alter" the data for you. However this would not be the great solution it sounds.
1/ Invoices already updated to the ledgers will still be updated to the ledgers even though they have been removed so you will have to repost them manually.
2/ We will remove items that have been flagged as having gone on the VAT return and so you will need to control VAT some other way for the next return.
3/ We will break the Bank Reconciliation as reconciled transactions will get removed.
---------------------------------
I guess it depends on how much data you have and how bad it is. I think working forward is generally a better option. If you find problems, reverse them out and re-key them.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
the problem was the accountant took a backup did what he had to do from his end and never returned the updated data. He even did the bank rec annually so there really is no connection between the data I hold and the data he held. It was all very unprofessional. I can only assume he took the annual movements and then did his own thing!
Who is online
Users browsing this forum: Semrush [Bot] and 2 guests