Excel/Sheets work

My business (restaurant) has been using two excel spreadsheets to essentially pay bills and then record them in a ledger for several years. I'm trying to simplify the process. Using our "transmittal" (the spreadsheet we pay invoices on), we enter the invoice date, payee, invoice number, g/l account number, and dollar amount, then they go to the ledger and enter just the date, payee, and amount in the appropriate area depending on the g/l account so we can tally how much total is spent in each account. If possible, I'd like to populate the expense ledger automatically when an invoice is entered on the transmittal. In other words, have the ledger look for the g/l account an invoice is charged to and copy that data to the next available cell. There is one file, but a separate sheet for each week's transmittal and then one expense ledger for the entire month. We used to use Excel, but are switching everything to Google Sheets this year if possible. Thanks, Rich