23 tasks, each one witnessed by the sources that watched the job — and behind every one, a prompt you can use tonight.
You’ll split time between number-crunching and checking paperwork. Morning might mean processing invoices for payment, entering them in QuickBooks, and reconciling cash totals from the register.
Afternoons often go to reviewing financial statements and preparing adjusting journal entries in Excel or Google Sheets, plus a quick audit-style transaction test if something looks off. You also report results to store or regional management at set times each week or month.
Expect Microsoft Excel and Google Sheets every day for budgets, forecasts, and reconciliations. Use QuickBooks for the store’s accounting ledgers and to record invoices and payments.
Adobe Acrobat and Google Docs handle scanned receipts, audit reports, and tax paperwork. If you prepare basic tax returns, TurboTax or similar packages may be used, but the heavy lifting is in Excel and QuickBooks.
A store accountant spends maybe 60% bookkeeping and 40% audit/review work, though that shifts by month. Daily tasks—processing invoices, posting entries, and preparing records—are bookkeeping.
Audit work—transaction testing, looking for irregularities, and pre-implementation checks—comes up during month-end, year-end, or if discrepancies appear. Both are routine parts of the role.
You can use AI to automate repetitive checks (like scanning for outlier transactions in Excel or Google Sheets), draft audit reports, or summarize long vendor statements. Always keep the original data and human-review outputs—AI can make plausible but wrong suggestions.
Never use AI to file taxes without human verification. For compliance and fraud checks, rely on system reports from QuickBooks or Access and then use AI only as an assistant, not the final decision-maker.
Start with transaction testing: sample 10–30 transactions per week and match invoices to receipts and bank entries in QuickBooks or Excel. Look for duplicate invoice numbers, abnormal amounts, or round-dollar patterns.
Run reconciliation: compare register totals to bank deposits and accounting ledgers. Use variance analysis on budgets vs. actuals and flag differences over a set threshold (for example, any variance >5% or $500) for deeper review.
Learn Excel well: VLOOKUP/XLOOKUP, pivot tables, SUMIFS, and basic macros to speed reconciliations. Get comfortable with QuickBooks—recording invoices, payments, and running balance reports.
Study basic tax rules relevant to your country and practice preparing simple returns in TurboTax or similar so you can calculate taxes owed. Mock audit exercises—matching receipts to entries—help a lot.