Daily Sales & Purchase Sheet update

I need my master Google Sheet brought up to date every single day with fresh sales and purchase entries covering both the product lines and the service work we handle. Each new row must arrive complete with:

• the exact transaction amount
• the customer’s name or account reference
• a clear description of the product or service involved

The spreadsheet is already laid out; what I’m missing is the consistent, accurate feed of data. You can source the figures from my invoices file (CSV export) and yesterday’s POS report, then append or reconcile them so the running totals, pivot summaries, and dashboards I’ve built remain correct.

Speed is important—I check the figures first thing each morning—so the update has to be in place before 9 a.m. GMT. A short note in a “Log” tab confirming the upload time and row count will be enough for sign-off each day.

I’m open to whatever method you prefer: manual entry for now, a Zapier or Make.com workflow, or a lightweight Apps Script that automates the pull, so long as the data lands where it should and the formatting stays intact.