Best way to fix cash/credit account totals in Books that came from Zoho Invoice?
Hello,
I am having an ongoing struggle with how to get my account totals in order. Here is my dilemma:
I moved to Books from Invoice about soon after Books was released. Somewhere in my transfer process, I did not start my bank/credit accounts off properly in terms of amounts (starting balances?) so now when I am reconciling my two accounts each month, I never am able to properly use an ending balance from my bank statements because even though ALL transactions are accurate in my digital records and the statement, Zoho always shows either a deficit or surplus at the end of reconciling.
Since I never had a chance to look into the problem, I have been "adjusting" my closing total for each month to merely allow my system to reconcile. But I know this is not right. I should be able to enter the closing total from my statements and have them match in Zoho without having to rig the numbers so I can push a reconcile through.
I have tried to enter credits/debits in my two accounts to offset the differences at points but it has never worked. The next month, my reconciling shows me as being off from the proper ending balance. I am frustrated as I do not know how to permanently fix this ongoing accounting error.
I know I should have started my move to Books with proper "Opening Balances" but I screwed up somewhere.
Can anyone suggest a way to fix this? I am fairly familiar with Books but do not have a formal accounting background. Thank you to any help.
www.FireLogic.net