Hi all,
I want to create a table to cross check the bank account statement.
Is there any way to create a table to calculate the balance base on the previous entry and cross check if it consistant with the "balance" entry?
Vinco
Are you trying to reconcile with the most recent transaction balance? You could make a 'Master' table where you summarize ALL withdrawals and deposits as fields into that table and compare to your opening balance to get your current, and then summarize your most recent balance value and compare.
If you're just trying to visually check - you could make a summary report also that just rolls up the totals and create a summary report formula that calculates the opening balance + deposits - withdrawal summaries.
A summary report has the option to do a running total. Maybe that is useful if you create a formula field is positive for the deposits and negative for the withdrawals and then show that field as a "running total" on a summary report. The summary report could summarize on date and then [Record ID#] to ensure it breaks on every record.
