Running Total, Opening & Closing Acct Balance in Cash Book

R

rushdhih

Dear Friends,
I am building a worksheet that records Cash-In/Cash Out and Cash Advance
Tracking and need (a) Running Balance (B) It Needs to show closing Cash
Balance for the current month and the opening balance for the following
month.
The data that needs to be manipulated is based on 4 colums as below:

A-Date
B - Cash-In
C-Cash - Out
D-Cash Advances and Settlements

Available Cash at any Time is calculated as follows
Cash-In Minus Cash-Out and Plus or Minus New Advances or Settlements
(Advances will be a positive amount whilesettlement will be a negative amount)

The Caculated Cash Balance at end of month need to be the following months
opening balance based on the date.

Is there also a possibiity to bring the Closing balnace to the Pivot Table
to be used for bank reconciliation purpose.

I dont want to use VBA Code, Instead only formulas.

Rushdhi
 
F

Fred Smith

Rather than a pivot table, why not just calculate the running balance in
column E?

Regards,
Fred
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top