Account balance not equal

[lingtring]

If I go to Inquiry, Financial, detailed and I export the transactions for a given month to excel (csv), and then add in Excel the credits and debits, the total for each it's different from the inquiry window that shows the balance for each month.

Why is this and how can I fix it?

 

[barbola]

Just a thought, but are you taking the beginning balance into consideration?

 

[lingtring]

Correct me if I'm wrong, but on the columns of credit and debit on the financial summary screen it should only show the total for the transactions on that period, with out adding the beggining balance.

 

[barbola]

The Account Balance field on the screen shows the current account balance regardless of what range of detail you are viewing.

If you want the net change for a given period, you may want to try using account rollup inquiry.

 

[lingtring]

I know what was happening, they used a currency that they shouldn't use on that account, and the report I was viewing was on original (currency), but when I changed it to functional, it gave me the correct amounts.

Thanks to all