Jump to content

Need Help - I cannot reset the income and profit


Recommended Posts

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 post
Share on other sites

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 post
Share on other sites
  • 2 years later...
  • 1 year later...
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 post
Share on other sites
  • 2 years later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...