I am using Calc to record our monthly accounts. We have a payment each month that is 5% of the previous months receipts. I got that part figured out. The problem is: the 5% shows up as a debit even before I write the check at the beginning of each month (February gets a check for January’s receipts). Therefore when I show the Expenses of Year to Date the 5% shows up at the total, even thought I have not written the check yet. : Is there any way to put a date qualifier on the 5% cell so its about will only be tabulated after the date it is sent (the first of the month)?
I’m not sure I grasp your concept, but if yoe have a due payment and a date from invoice/ transaction you may only need a mor complex formula like
=IF( TODAY >= first of next month; 5% ; 0% )
.
Maybe you can upload a small sample of your data
1 Like
I’m sorry if it doesn’t make sense. I am a novice with this program.
Do yourself a favor and use a mature accounting program. Learning about spreadsheets for the next half year until you get some poor surrogate is beyond reason. Not a single accounting program is based on spreadsheets. No serious developer producing software products for salesmen would ever store business data on sheets.
Someone really proficient with spreadsheets may be able to develop a poor solution on sheets usable by himself exclusively. The fact that this question comes up since 30 years with no viable solution tells more than a thousand words.
Thank you for your advice.