I still can't figure out what this is doing functionally. I get that it somehow tracks receipts but that's as far as I can get. It would help to have more complete sample data. Can you address the following:

  1. Your worksheets only have a few rows of data, with many blank rows in between the populated rows.
  2. Why are so many rows left blank?
  3. What determines what rows are populated?
  4. What determines what data is entered in the rows that do have data?
  5. The only purpose of row 4 seems to be to contain the date for the first day of the month. Is that correct? What does BBF mean? If it is not part of your receipt data I would put it somewhere else on the sheet, although there is no real harm in it.