Ayres

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

I have the same problem. The solution above doesn't work. The system simply doesn't allow me to change the opening balance.

Hi There.

For some unknown reason, I had placed an opening balance on the accounts payable account chart, many months ago. Now we need to correct it, as it was a mistake. But surprisingly, all other accounts I am allowed to place and change the opening balance, but on teh accounts Payaable Accoutn I can't.

Does anyone knows how I could do that? I treid at Chart of Accounts / Editing. No success, the opening balance appears on it, and it is impossible to be changed.

Best Regards

Ayres