I created a database for invoices and payments and I am trying to expand and include a bank reconciliation.
I am still trying to figure out how I can make this happen as I am not sure if there is an option to include a balance brought forward and balance carried forward.
The report or query will be generated by date, for example from 1st May to 31 May, thus i need the balance to be brought forward with the balance till end of April.....to give the total of the balance which is either a debit or credit.
any suggestion on how I need to structure this from scratch? I would like to include in my current database to have one database as I would then need to link my expenses to the reconciliation.
thank you in advance for your guidance.
I am still trying to figure out how I can make this happen as I am not sure if there is an option to include a balance brought forward and balance carried forward.
The report or query will be generated by date, for example from 1st May to 31 May, thus i need the balance to be brought forward with the balance till end of April.....to give the total of the balance which is either a debit or credit.
any suggestion on how I need to structure this from scratch? I would like to include in my current database to have one database as I would then need to link my expenses to the reconciliation.
thank you in advance for your guidance.