How do I reconcile and get correct balance for an account?

Unless you just opened the account this month and didn’t have a previous balance, the problem is likely that you haven’t filed in columns I and J for each account. It can be a pain in the butt, but it’s necessary to figure out an opening balance and date so you’re starting from a known good point. Read through the Setup section again in the documentation for some tips on how to do this. Once you’ve established what the opening balance and date are for each account, it’s much more likely the numbers will come up clean and balance properly.