Daily Sales & Purchase Updates

I maintain a Google Sheets workbook that tracks every sale and purchase my business makes. Both sides of the ledger must be current at the start of each trading day, so accuracy and consistency are critical.

Here’s how the workflow runs:
• By 8 p.m. my time I’ll drop the day’s till reads, card-machine summaries, and supplier invoices into a shared Drive folder (usually PDFs or clear photos).
• You open the master sheet, locate the correct date row and enter the figures in the Sales and Purchases tabs, matching the headings already in place (SKU, quantity, net, tax, gross, supplier/customer, method of payment).
• The sheet contains formulas, pivot tables and charts. Data has to be typed in—never overwrite existing formulas or named ranges.
• Once numbers balance with the source docs, leave a brief note in the “Checked” column and mark the Drive files as “entered”.

Acceptance criteria
– All fields copied exactly; no rounding or transcription errors.
– Daily cut-off met (entries finished before 10 p.m. UTC).
– Existing formulas and conditional formatting remain functional.
– Random spot checks throughout the week show 100 % accuracy.

If you have solid spreadsheet skills and an eye for detail, this is a simple but ongoing task that keeps our accounts crystal clear.