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.
what does it tell though ? 
Old teacher’s saying:
No learning without playing.
If you play with spreadsheets, you may not soon find a reliable solution for your budget, but you can learn learning about computer software.
No serious developer ... has started to get experienced in the field creating a database.
No real reader has started with “Lord of the Flies”.
Databases tend to be dull; dull and difficult in a sense. Developers of database software seem to think the same way, and prefer playful developing a new database program over excessive usage of the edxisting ones. Why else should be so many programs of the kind?
But I agree on your main point: One can learn a lot by creating a solution oneself. It does not matter, if programming language, spreadsheet or database for this.
1 Like
Off Topic
Two of my favorites:
1 Like