Skip to main content
Question

Accummulative bank account checking

  • Feb 16, 2024 9:03 AM UTC
  • 0 replies
  • 66 views

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



------------------------------
Yiu Vinco
------------------------------
This topic has been closed for replies.

Forum|alt.badge.img+9
  • Qrew Colonel
  • Feb 20, 2024 3:43 PM UTC

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. 



------------------------------
Chayce Duncan
------------------------------