I am working to create a simple accounting application, composed of a monthly journal entry sheet (MJE), a monthly detailed journal ledger (DGL) sheet, and a monthly balance or financial statement (FS).
I have been trying to use ChatGPT to teach myself the basics of some of the entry summation and listing, but my free level reached its limit and I lost all of my notes.
I am uploading a copy of my workbook. My current goal is to list the journal entries according to account number. The chart of accounts, or the listing of account numbers is on the FS page. The listing of all journal entries is on the MJE page. I think I am able to retrieve the account number and name from the FS sheet and put it into the correct cells in the DGL sheet, but I have forgotten how to extract a listing of journal entries from the MJE sheet, place them in an account section on the DGL sheet, and cause the operation to iterate through all of the accounts listed on the FS sheet.
Can anyone help?
Thanks,
Kirk
Cash Book- example - WORKING-2411115 a.ods (29.0 KB)