Please let me know if excel can automatically perform debits and credits.
For example:
1.After an invoice is made. Excel will automatically deduct the number of the items sold in the invoice in the stock sheet.
2.Since the invoice was not paid. Excel will add the due amount in the customer sheet. Please note that there are more than one customer.
3.If any customer pays any amount. I will issue a receipt to the customer. Excel will deduct the amount paid in the customer sheet and increase the account balance in my bank or cash sheet.
I will be grateful if you could manage some of your time to work on my problem.
Thanks in advance.
For example:
1.After an invoice is made. Excel will automatically deduct the number of the items sold in the invoice in the stock sheet.
2.Since the invoice was not paid. Excel will add the due amount in the customer sheet. Please note that there are more than one customer.
3.If any customer pays any amount. I will issue a receipt to the customer. Excel will deduct the amount paid in the customer sheet and increase the account balance in my bank or cash sheet.
I will be grateful if you could manage some of your time to work on my problem.
Thanks in advance.
