How to handle annual service (Maintenenace) fee received from customer, and automatically generate its sales monthly
Here are what we would like to do:
- Annual service invoice to customer
DR AR
CR Advanced receipts
- Cash received from customer
DR Cash
CR AR
- Monthly sales
We want this monthly sales amount to be automatically calculated based on the # of service contract months)
This amount would be annual service fee devided by the # of service months
DR Advanced receipts
CR Sales
In addition to this, we would like to check how much sales and advanced payment are remaining per customer on a report or something.
Please advise.