Forum Discussion

YiuVinco's avatar
YiuVinco
Qrew Member
4 months ago

Accummulative bank account checking

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
------------------------------

2 Replies

  • 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
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend

      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.



      ------------------------------
      Mark Shnier (Your Quickbase Coach)
      mark.shnier@gmail.com
      ------------------------------