accountingfac Posted November 28, 2012 Share Posted November 28, 2012 I have just installed Express Accounts and wanted to get used to it and did dummy invoices. Only thing is I can not reset the income and profit to zero even though I have deleted the invoices. Can somebody please help as need to get this up and running. Many thanks for your time. Link to comment Share on other sites More sharing options...
Windburn Posted November 28, 2012 Share Posted November 28, 2012 I would try going into the Journal and deleting everything that is in there. Hope this helps Link to comment Share on other sites More sharing options...
accountingfac Posted November 28, 2012 Author Share Posted November 28, 2012 No there is nothing in the Journal, really struck on what to do Thank you for time Link to comment Share on other sites More sharing options...
accountingfac Posted November 29, 2012 Author Share Posted November 29, 2012 I meant stuck Link to comment Share on other sites More sharing options...
shtewps Posted November 30, 2012 Share Posted November 30, 2012 I would also like to know the answer to this question. I've set up my business profile (which took some time) and created some invoices. I deleted the invoices yet there are still some remaining balances. Specifically "historical balancing" which I cant seem to edit the value which is very strange. The fact that I cant remove a sale and have it properly reflected in the balances is very weird. How can we get back to a clean slate or properly remove sales without deleting EVERYTHING. Link to comment Share on other sites More sharing options...
shtewps Posted November 30, 2012 Share Posted November 30, 2012 Alright I figured out how to reset specific opening balance values manually. This worked great for me as I was able to edit any account and bring everything back to $0.00 balances without deleting the business profile which I had already created! 1. Find out which accounts are still reporting an open balance (even though you have deleted any applicable invoices) - Reports > Balance Sheet... > View 2. If any of the items listed in this report are showing a balance, note their account number and go to View > Chart of Accounts.. 3. Open the account you would like to clear or mofify the balance of and change the "opening balance field". If any of these accounts show this field as greyed out (not editable), in my case it was 'historical balances'... proceed to step 4! 4. Back up your current data - Accounts > Back up Data... > Backup to removable drive > Select some place ie: your desktop 5. Navigate to the 'Accounts' folder inside your backup folder (ie: c:\...\...\desktop\ExpressAccounts-Backup-2012-XX-XX\Accounts) 6. Select the account number of the desired account you with to edit and use a text editor such as Notepad++ or simply notepad to edit the account file 7. Notice the balance will be in a couple of locations within this file so make sure you edit both locations to whatever value you prefer (ie: "0") and save. 8. Restore your backup! - Accounts > Restore Data... > Restore from Backup > 'your backup directory here' 9. Run the report for your Balance Sheet again and behold your new (proper) balance! Link to comment Share on other sites More sharing options...
gehage Posted September 19, 2015 Share Posted September 19, 2015 delete of all cutomers Link to comment Share on other sites More sharing options...
Ayres Posted May 24, 2017 Share Posted May 24, 2017 On 2012-11-30 at 3:11 AM, shtewps said: Alright I figured out how to reset specific opening balance values manually. This worked great for me as I was able to edit any account and bring everything back to $0.00 balances without deleting the business profile which I had already created! 1. Find out which accounts are still reporting an open balance (even though you have deleted any applicable invoices) - Reports > Balance Sheet... > View 2. If any of the items listed in this report are showing a balance, note their account number and go to View > Chart of Accounts.. 3. Open the account you would like to clear or mofify the balance of and change the "opening balance field". If any of these accounts show this field as greyed out (not editable), in my case it was 'historical balances'... proceed to step 4! 4. Back up your current data - Accounts > Back up Data... > Backup to removable drive > Select some place ie: your desktop 5. Navigate to the 'Accounts' folder inside your backup folder (ie: c:\...\...\desktop\ExpressAccounts-Backup-2012-XX-XX\Accounts) 6. Select the account number of the desired account you with to edit and use a text editor such as Notepad++ or simply notepad to edit the account file 7. Notice the balance will be in a couple of locations within this file so make sure you edit both locations to whatever value you prefer (ie: "0") and save. 8. Restore your backup! - Accounts > Restore Data... > Restore from Backup > 'your backup directory here' 9. Run the report for your Balance Sheet again and behold your new (proper) balance! I have the same problem. for some reason I had an ammount of Accounts Payable Oppening Balance. today 1,5 year after startign teh busienss, need to adjust that. But If I simple edit the file as you sugest I am afraid the all over data will be broken such as actual balance etc etc Link to comment Share on other sites More sharing options...
dtruesly Posted November 2, 2019 Share Posted November 2, 2019 This help a great deal Thank you!!! Link to comment Share on other sites More sharing options...
ndrc81 Posted December 23, 2022 Share Posted December 23, 2022 I specifically signed up just to leave a post to thank the OP who found the workaround. This worked like a charm for correcting the 'historical balances' problem. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now