20 tasks, each one witnessed by the sources that watched the job — and behind every one, a prompt you can use tonight.
You’ll match supplier invoices to purchase orders, enter invoices into QuickBooks or Excel, and code each document to the right expense account. Expect several hours entering data, plus time reconciling bank transactions and checking that payments are scheduled.
You’ll also file vendor paperwork, answer supplier phone questions in Outlook or on the phone, and run simple reports (trial balances, unpaid invoices) for your supervisor using Excel or the accounting system.
Learn both, but start with Excel. Excel is used every day for trial balances, reconciliations, and pivoting invoice data. Know formulas (SUM, VLOOKUP/XLOOKUP) and basic pivot tables.
QuickBooks (or another accounting system) is where you post invoices, code expenses, and produce financial reports. If you can use Excel plus QuickBooks entry and reporting, you’ll handle most tasks listed above.
Yes, but use AI cautiously. AI can extract invoice data into Excel or QuickBooks drafts, and suggest account codes, saving time on data transfer from journals to ledgers. Always verify AI outputs against originals and company chart of accounts.
Never rely on AI to submit payments or file tax forms. Keep human review for accuracy, compliance (tax returns, pension forms), and sensitive items like workers’ compensation.
Employers look for strong Excel skills, basic accounting knowledge (debits/credits, trial balance, general ledger), and familiarity with QuickBooks or similar systems. A certificate in bookkeeping or QuickBooks is useful.
Practical skills matter: invoice coding, bank reconciliation, preparing trial balances, and completing simple government forms. Volunteer or internship experience doing invoicing or bank reconciliations is a big plus.
Accounts Payable focuses on money your company owes: processing supplier invoices, scheduling payments, and coding expenses. Bookkeepers cover both payables and receivables, plus ledger transfers and balance-sheet work.
Accounts Receivable handles incoming cash, customer invoices, and collections. AP clerks seldom call customers; they file vendor documents, maintain inventory records related to purchases, and prepare vendor-related reports.
Attention to detail. Small errors in invoice numbers, amounts, or account codes lead to wrong ledger entries, failed reconciliations, and bad financial reports. Reconcile bank transactions and trial balances each month to catch mistakes.
Combine attention to detail with habit: always check vendor invoices against order forms, keep supporting documents in SharePoint or filing cabinets, and run an unpaid-invoice report before scheduling payments.