Best Way To Track Account Balances?

[CharlesWhiteman]

In my Db I have TblInvoices which tracks all invoices generated. I have also generated TblReceipts to track payments received. I'm pondering on the nest way to track account balances etc but happy to take advice?

PK/FK is based on CompanyCode

Do I?

Create a query to take all the associated invoices then create a subquery to do a sum on the total. Then:

Create a query on the TblReceipts and subtract one from the other

Is this the best way?

 

[CharlesWhiteman]

Thanks, this is what I did.