View Single Post
 
Old 12-26-2018, 12:00 AM
tomplom tomplom is offline Windows 10 Office 2016
Novice
 
Join Date: Dec 2018
Posts: 1
tomplom is on a distinguished road
Default How to find the wrong number when you want to hit 0?

Hi Guys.

I am doing some accounting for a charity organization. I have one transaction account that should be 0,- in the end of the year. Several (sub) organizations use same bankterminal to save money and then I pay out that money to their account.

I've importet all transactions from the bank to excel. They are sortet in columns: in (+) out (-) So if everthing was right all year the accont should be in 0,- 2458 came in I pay out 2458.
Lot of transactions. Is there a way to find where the problem are. Everey number should equal it self out. Which numbers aren't?

Thanks in advance.
Reply With Quote