checking account / track my petty cash application

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
I want to create a "checkbook" register to manage our petty cashI'm creating an application to manage our petty cash.
We will track the date, paid to, description and debit or credit amount.

I want a running total (Like a checkbook register or banking statement) 
I've started by creating the application.
I have a numeric (currency) field for the debit entry called [Transaction Amount] and a numeric (currency) field for the credit entry called [Deposit Amount] and a numeric formula field for [Transaction Ending Balance]
In case I need it - I also created an additional numeric formula filed called [Balance Forward].

I need to learn how to do a formula that will allow me to show a running balance in our bank account ("petty cash").

I'm looking for something like this:

The [Transaction Ending Balance] will pull the last record's ending balance - [Transaction Amount] + [Deposit Amount] and result in a new [Transaction Ending Balance] or perhaps results would need to go into a new field called [Balance Forward] for instance.

e.g. show the previous records' [ending balance] - current record's [Transaction Amount] + the current record's [Deposit Amount], which would in turn then be the "new balance forward amount" so the next record can work off of the last record and so on.....
Photo of Ken

Ken

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of David

David

  • 866 Points 500 badge 2x thumb
Sounds like you need two tables: Account & transactions.
Yes, you need two tables and then create a summary of the total deposits and the total withdrawals and subtract them to get the current balance.  

Its not so easy to get a running balance unless you create a summary report where it does give you the option to have a running totals.  but your summary report would always need to start at the very beginning of the first entry.