Schema CPA
BlogSign inStart free

Recent posts

The newest posts from every category, most recent first.

See the most recently updated posts

  1. IRS Security Six: the six protections, explained

    The IRS Security Six in plain terms: antivirus, firewalls, multi-factor login, backups, drive encryption and VPNs, with a quick check for each one.

    October 16, 2026Client portals and data security

  2. 1099-K Explained: Card and App Payments for Preparers

    The 1099-K explained for firms: gross payments rather than income, who issues it, and how to reconcile it to the books when fees and refunds intervene.

    October 16, 2026Tax forms, W-9s and payroll paper

  3. General Ledger to Excel: Every Format Clients Send

    How to get a client's general ledger to Excel from a PDF, a software export or a scan, with one row per posting and totals that match the source report.

    October 16, 2026Ledgers and financial statements

  4. Tax Season Post-Mortem: Questions for Next Year

    Run a tax season post-mortem with your staff: the questions to ask, the numbers to pull, and how to turn the answers into next season's plan in May.

    October 16, 2026Tax season workflow

  5. C Corporation Tax Checklist: Documents for the 1120

    A C corporation tax checklist for Form 1120: books, officer pay, dividends, estimated payments, carryovers and the book-to-tax items to request every year.

    October 16, 2026Tax checklists and organizers

  6. Trial Balance Mapping: Accounts to Statement Lines

    Trial balance mapping explained: grouping each client account into a statement line or tax line, building a reusable map, and catching unmapped accounts.

    October 16, 2026Ledgers and financial statements

  7. 1099-NEC vs 1099-MISC: Which Form a Payment Needs

    1099-NEC vs 1099-MISC: which payments go on each form, how rent and attorney fees are split, the filing deadlines, and how to classify ledger payments.

    October 16, 2026Tax forms, W-9s and payroll paper

  8. Cash Flow Statement From a Trial Balance, Step by Step

    Prepare a cash flow statement from a trial balance: two year-end balances, operating, investing and financing changes, and a proof cell that ties to cash.

    October 16, 2026Ledgers and financial statements

  9. How to Organize Client Documents for Bookkeeping Clients

    How to organize client documents that arrive every month from bookkeeping clients: statements, receipts, payroll reports and ledgers, kept in order all year.

    October 16, 2026Sorting and organizing client files

  10. 1099-G Explained: Unemployment and State Tax Refunds

    The 1099-G explained: unemployment benefits, state tax refunds and grants by box, when the refund is taxable, and what to do with a fraudulent form.

    October 16, 2026Tax forms, W-9s and payroll paper

  11. Missing Bank Statements: How to Find Gaps in a Run

    Missing bank statements break every reconciliation. Learn to spot gaps in a run of statements by period dates and balances before the books or return are done.

    October 15, 2026Statement reconciliation

  12. Multi Step Income Statement Excel Template, Row by Row

    Build a multi step income statement in Excel: gross profit, operating income and other income rows, margin formulas, and step codes on the trial balance map.

    October 15, 2026Ledgers and financial statements

  13. Bank Statement Date Formats in Excel: Fixing Text Dates

    Why bank statement date formats break in Excel, how to turn text dates into real dates, and how to handle dates with no year or a swapped day and month.

    October 15, 2026Bank statements to Excel

  14. Tax Document OCR: Getting Accurate Numbers Off Forms

    How tax document OCR reads W-2s, 1099s and K-1s, how accurate it is on tax forms, and the built-in checks that catch a wrong digit before it reaches a return.

    October 15, 2026Tax forms, W-9s and payroll paper

  15. Balance Sheet Does Not Tie to Trial Balance? Find Why

    Why a balance sheet does not tie to the trial balance: date and basis mismatches, current-year earnings, unmapped accounts and late entries, checked in order.

    October 15, 2026Ledgers and financial statements

  16. Backup Withholding and Missing W-9: The 24% Rule

    Backup withholding and a missing W-9: when a payer must withhold 24%, what a B-notice changes, and how the withholding is deposited and reported on Form 945.

    October 15, 2026Tax forms, W-9s and payroll paper

  17. Client-Prepared Financial Statements Review, Step by Step

    How to approach a client-prepared financial statements review: tie to the ledger, test key balances, scan for omissions and document what you relied on.

    October 15, 2026Ledgers and financial statements

  18. Trial Balance Import: From Client File to Workpapers

    Trial balance import from a client's export or PDF into Excel and workpaper tools: the columns an import needs, sign rules, and the checks to run after.

    October 15, 2026Ledgers and financial statements

  19. QuickBooks Working Trial Balance in Desktop, Explained

    The QuickBooks working trial balance in Desktop: where it lives, its beginning, adjustment and ending columns, and how to post adjusting entries from it.

    October 15, 2026Ledgers and financial statements

  20. 1099 OCR: Reading Every 1099 Variant Without Retyping

    1099 OCR for firms: which 1099 variants to expect, consolidated brokerage statements, substitute forms, and a 1099 to Excel layout that keeps every box.

    October 15, 2026Tax forms, W-9s and payroll paper

  21. Corrected W-2 After Filing: When a W-2c Means Amending

    A corrected W-2 after filing arrives as a W-2c. Learn which box changes affect tax owed, when to amend, and what to do when the employer will not correct it.

    October 15, 2026Chasing missing documents

  22. Trial Balance in Excel for Review Engagements

    Build a trial balance in Excel for review engagements: unadjusted, adjustment and adjusted columns, prior-year variance, tickmarks and lead sheet tabs.

    October 15, 2026Ledgers and financial statements

  23. How to Request Missing Bank Statements From a Client

    How to request missing bank statements from a client: name the account and months, say where to download them, and get complete PDFs back on the first try.

    October 15, 2026Statement reconciliation

  24. Form 1098 Mortgage Interest Statement: What to Pull

    Read a Form 1098 mortgage interest statement box by box: interest, points, mortgage insurance, escrowed property tax, and the property tax bill check.

    October 15, 2026Tax forms, W-9s and payroll paper

  25. Balance Sheet to Excel From a PDF or Software Report

    How to get a balance sheet to Excel from a PDF, a scan or a software report: keep the line hierarchy, the subtotals and the period columns intact.

    October 15, 2026Ledgers and financial statements

  26. 1099 Vendor W-9 Collection Before the January Deadline

    1099 vendor W-9 collection for year-end: build the vendor list from the ledger, collect a W-9 before paying a contractor, and handle vendors who never reply.

    October 15, 2026Tax forms, W-9s and payroll paper

  27. A Tax Document Reminder Email Template for Each Stage

    A tax document reminder email template for each stage of the season, from the first nudge to the final notice, with subject lines and the missing list built in.

    October 15, 2026Chasing missing documents

  28. W-9 TIN Matching: Format Checks vs the IRS Program

    W-9 TIN matching explained: what a TIN format check catches, how the IRS TIN Matching program works, what each result means, and what to do on a mismatch.

    October 15, 2026Tax forms, W-9s and payroll paper

  29. Financial Statement Extraction Into Structured Rows

    Financial statement extraction turns statement pages into labeled rows: line items, periods, subtotals and the checks that prove every extracted figure.

    October 15, 2026Ledgers and financial statements

  30. Trial Balance to Balance Sheet Excel Workbook, Step by Step

    Turn a trial balance to a balance sheet in Excel with SUMIFS on a mapping column, a retained earnings roll and a check cell that proves the sheet balances.

    October 14, 2026Ledgers and financial statements

  31. 1099-SA and 5498-SA: Reading HSA Forms for a Return

    How the 1099-SA and 5498-SA fit together for an HSA: distribution codes, contributions versus W-2 code W, and the tie-out on Form 8889 for the return.

    October 14, 2026Tax forms, W-9s and payroll paper

  32. Classified Balance Sheet Excel Layout, Current to Long-Term

    Lay out a classified balance sheet in Excel: current and long-term sections, the current portion of debt, working capital and subtotals from the trial balance.

    October 14, 2026Ledgers and financial statements

  33. When Do 1099s Arrive? Dates by Form

    When do 1099s arrive? The furnishing dates for each common 1099, the 1098 and the 5498, and why brokerage forms and corrected copies come later.

    October 14, 2026Chasing missing documents

  34. Clean CSV Before Importing to QuickBooks: A Checklist

    Clean CSV files before importing to QuickBooks: strip totals and running balances, fix dates and signs, drop pending rows, and save a file that uploads.

    October 14, 2026QuickBooks, Xero and Excel export

  35. Adjusting Journal Entries and the Trial Balance

    How adjusting journal entries change the trial balance: accruals, deferrals and depreciation, an adjusted column, and an entry log the client can post.

    October 14, 2026Ledgers and financial statements

  36. Cryptocurrency Tax Document Checklist for Clients

    A cryptocurrency tax document checklist: exchange tax forms, full transaction histories, wallet records, cost basis and staking income to request from clients.

    October 14, 2026Tax checklists and organizers

  37. Personal Financial Statement Excel Layout for Lenders

    Prepare a personal financial statement in Excel for a lender: asset and liability schedules, net worth, guarantees, and the statement behind each figure.

    October 14, 2026Ledgers and financial statements

  38. WISP template for tax professionals, section by section

    Fill in a WISP template for tax professionals one section at a time: the asset inventory, risk list, safeguards, response plan and the sign-off page.

    October 14, 2026Client portals and data security

  39. Catch-Up Bookkeeping Bank Statements: Where to Start

    Catch-up bookkeeping starts with the bank statements: collect the full run, reconcile a year of statements in order and decide what to rebuild from scratch.

    October 14, 2026Statement reconciliation

  40. Email encryption for accountants: when and how to use it

    Email encryption for accountants explained: TLS versus message encryption, how to send an encrypted message, and when a client should get a link instead.

    October 14, 2026Client portals and data security

  41. Tax Season Workflow: The Stages of a Return in a Firm

    A tax season workflow mapped from intake to e-file: each stage a return passes through, who owns it, and the handoff where returns usually stall.

    October 13, 2026Tax season workflow

  42. Ransomware protection for accounting firms, layer by layer

    Ransomware protection for accounting firms: how attacks get in, backups that survive them, settings that block them, and the first hour after one hits.

    October 13, 2026Client portals and data security

  43. How to Import Bank Transactions into QuickBooks Desktop

    How to import bank transactions into QuickBooks Desktop: Web Connect files from the bank, Batch Enter in some editions, and what to do when neither fits.

    October 13, 2026QuickBooks, Xero and Excel export

  44. How to Collect Bank Statements From Clients

    How to collect bank statements from clients: which format to ask for, downloads versus paper, every account and month, and statements from joint accounts.

    October 12, 2026Collecting client documents

  45. WISP for tax preparers: the written plan the IRS expects

    What a WISP for tax preparers is, who must keep one, the elements the FTC Safeguards Rule requires, and how to size the plan to a solo or small practice.

    October 12, 2026Client portals and data security

  46. Retained Earnings Does Not Match Prior Year? Trace It

    Why opening retained earnings does not match the prior year: late postings, unposted adjustments, draws and conversions, traced with a rollforward table.

    October 12, 2026Ledgers and financial statements

  47. FTC Safeguards Rule for tax preparers: what it requires

    Why the FTC Safeguards Rule covers tax preparers, what it requires under the Gramm-Leach-Bliley Act, the small-firm exemptions and the FTC breach notice.

    October 10, 2026Client portals and data security

  48. How to stop emailing tax documents without losing clients

    How to stop emailing tax documents: why email and texts expose client data, the policy wording to send clients, and what to do when an attachment still arrives.

    October 9, 2026Client portals and data security

  49. Security awareness training for accounting staff: a plan

    Plan security awareness training for accounting staff: what the rules require, a 12-month calendar, seasonal onboarding and the records to keep.

    October 9, 2026Client portals and data security

  50. Collecting Documents for an Amended Return, Step by Step

    Collecting documents for an amended return: the original return as filed, the corrected form and what it replaces, state copies, and a short request list.

    October 9, 2026Collecting client documents

  51. Missing 1095-A: Getting the Marketplace Form

    What to do about a missing 1095-A: where to download the Marketplace form, why the premium credit needs it, and how to handle a corrected or wrong one.

    October 9, 2026Chasing missing documents

  52. When a K-1 Arrives Late: Wait, Extend or Estimate

    When a K-1 arrives late: when partnerships, S corporations and trusts issue K-1s, why they slip, and whether to wait, extend or file with an estimate.

    October 9, 2026Chasing missing documents

  53. IRS Wage and Income Transcript for Missing Forms

    How to use the IRS wage and income transcript for missing forms: pulling it, when this year's data is complete, and what it leaves out before you file.

    October 9, 2026Chasing missing documents

  54. Access controls for accounting firm staff, step by step

    Set access controls for accounting firm staff: map roles to client folders, give least privilege, review access each quarter and offboard on the last day.

    October 9, 2026Client portals and data security

  55. Expat Tax Document Checklist: Foreign Income and Accounts

    An expat tax document checklist: foreign pay records, foreign account balances, travel days, housing costs and foreign tax paid to request from clients abroad.

    October 8, 2026Tax checklists and organizers

  56. Secure upload link vs client portal: which fits your firm

    A secure upload link vs a client portal, compared on client effort, what each protects, two-way exchange and staff upkeep, with a rule for picking per client.

    October 8, 2026Client portals and data security

  57. Email Attachments vs Upload Link for Tax Documents

    Email attachments vs upload link for tax documents: what each costs the firm in sorting, missed files and size limits, and when each one is the right choice.

    October 8, 2026Collecting client documents

  58. Busy Season Staffing for Accounting Firms

    Busy season staffing for accounting firms: how many people to add, which roles seasonal staff can fill, how to onboard them, and how to limit burnout.

    October 8, 2026Tax season workflow

  59. Bank Feed vs CSV Upload in QuickBooks: When to Use Each

    Bank feed vs CSV upload in QuickBooks: how far back each reaches, accuracy, effort for the firm, and when to run both on one account without doubles.

    October 8, 2026QuickBooks, Xero and Excel export

  60. Secure client portal for CPA firms: controls to check

    The controls that make a secure client portal for CPA firms: encryption, login rules, access logs, link expiry and vendor reports, and how to verify each one.

    October 8, 2026Client portals and data security

  61. Tax Season Deadline Calendar for Accounting Firms

    A tax season deadline calendar for accounting firms: each IRS due date from January to October, and the internal finish date staff work to before it.

    October 7, 2026Tax season workflow

  62. How Often to Reconcile Bank Accounts: Monthly or Less?

    How often to reconcile bank accounts: monthly, quarterly or yearly cadences compared by volume and risk, and when a client account needs weekly checks.

    October 6, 2026Statement reconciliation

  63. How to Get Clients to Send Tax Documents on Time

    How to get clients to send tax documents on time: a clear deadline, a short personal list, one place to upload, and engagement terms that make lateness cost.

    October 6, 2026Chasing missing documents

  64. Client Document Reminders: When and What to Send

    Client document reminders that get answers: a dated schedule from first request to extension call, what each reminder says, and which ones to automate.

    October 5, 2026Chasing missing documents

  65. Accounting Firm Automation Software: Where It Fits

    Compare kinds of accounting firm automation software by the job each one removes, and see which manual steps in a firm are worth automating first.

    October 5, 2026Tax season workflow

  66. How to Build a Client Tax Organizer Clients Finish

    How to build a client tax organizer people actually complete: which questions to keep, how to word them, how long it should run, and printable versus online.

    October 4, 2026Tax checklists and organizers

  67. Stale-Dated and Voided Checks in a Bank Reconciliation

    How to treat stale-dated and voided checks in a bank reconciliation: when a void is safe, what replaces it in a closed month, and when to write a check back.

    October 4, 2026Statement reconciliation

  68. Secure file sharing for accountants: a setup guide

    Set up secure file sharing for accountants: choose a sharing method, lock down link settings, name an owner for each share and close shares after the season.

    October 4, 2026Client portals and data security

  69. Invoice to Excel: Turn PDF Invoices Into One Sheet

    Invoice to Excel, step by step: lay out the sheet, convert each PDF invoice to rows, fix numbers stored as text, and avoid exports that break later imports.

    October 4, 2026Receipts and invoices

  70. How to Chase Clients for Documents Without Nagging

    How to chase clients for documents in a fixed follow-up workflow: who owns each client, when to call instead of email, and how many reminders to send.

    October 3, 2026Chasing missing documents

  71. OCR Receipt Scanner: How Receipt OCR Reads a Photo

    How an OCR receipt scanner works: the fields receipt OCR pulls from a photo, how it differs from invoice OCR, and where totals, tips and tax get misread.

    October 3, 2026Receipts and invoices

  72. Extension Strategy for Tax Firms: When to File Them

    An extension strategy for tax firms: decide which returns to extend and when, explain it to clients, and spread the work into the months after April.

    October 3, 2026Tax season workflow

  73. Document Request Email to Clients: Templates That Work

    Document request email templates to send clients: subject lines, a clear list of what to send, one place to send it, and a date, ready to copy and adapt.

    October 3, 2026Collecting client documents

  74. How to Import Bank Transactions into QuickBooks Online

    How to import bank transactions into QuickBooks Online by hand: the upload-from-file screen, column mapping, picking the account and reviewing each row.

    October 3, 2026QuickBooks, Xero and Excel export

  75. Encryption at rest vs in transit, for accounting firms

    Encryption at rest vs in transit in plain terms: what each one protects in a firm, where client files sit unprotected, and the questions to ask a vendor.

    October 3, 2026Client portals and data security

  76. Missing 1098-T: Claiming Education Credits Without It

    A missing 1098-T: where students download it, when an education credit can still be claimed without one, and which payment records to collect instead.

    October 2, 2026Chasing missing documents

  77. IRS Publication 4557: a safeguarding checklist for firms

    IRS Publication 4557 turned into a working checklist: what each part asks a tax firm to do about safeguarding taxpayer data, and how to record that it is done.

    October 1, 2026Client portals and data security

  78. Filing an Extension Because of Missing Documents

    Filing an extension because of missing documents versus filing now and amending later: what Form 4868 does and does not cover, and how to decide per client.

    October 1, 2026Chasing missing documents

  79. Secure document destruction for accountants: a how-to

    Secure document destruction for accountants: shredding paper, wiping drives and cloud copies, keeping a destruction log, and what the Disposal Rule expects.

    October 1, 2026Client portals and data security

  80. How to Import Bank Statements into Xero, Step by Step

    Import bank statements into Xero step by step: the statement import screen, file types Xero accepts, PDF statements, and fixing a statement line imported twice.

    September 29, 2026QuickBooks, Xero and Excel export

  81. Corrected 1099 After Filing: What Preparers Do Next

    A corrected 1099 after filing, or a 1099 the client forgot to send: how to judge whether the change matters and when an amended return is needed.

    September 29, 2026Chasing missing documents

  82. IP PIN for tax clients: who needs one and how to get it

    What an IP PIN does for tax clients, which clients should get one, how they request it, and how to collect the new PIN each season without delays.

    September 27, 2026Client portals and data security

  83. How to Collect Tax Documents From Clients, Start to Finish

    How to collect tax documents from clients across a whole season: the first request, one place for every file, batches, and knowing when intake is done.

    September 26, 2026Collecting client documents

  84. How to File Taxes With Missing W2 Forms

    How to file taxes with a missing W2: the employer and IRS steps, building Form 4852 from pay stubs, and what to do when a client's W-2 never arrives.

    September 25, 2026Chasing missing documents

  85. Bank Reconciliation Template in Excel, Built Step by Step

    Build a bank reconciliation template in Excel: the format, the columns and formulas, and a simple layout you can reuse every month for each client account.

    September 25, 2026Statement reconciliation

  86. How to Reconcile Merchant Processor Deposits to Sales

    Reconcile merchant processor deposits to card sales: gross up each net payout for fees, refunds and chargebacks, and place batches in the right month.

    September 22, 2026Statement reconciliation

  87. Trial Balance Software for Accounting Firms: What to Ask

    What trial balance software should do for an accounting firm: import, mapping, adjusting entries, prior-year rollforward, lead sheets and Excel output.

    September 15, 2026Ledgers and financial statements

  88. IRS Audit Checklist: Records to Gather for a Client

    An IRS audit checklist for firms: read the notice, list each examined item, gather the records behind it and prepare the client before the examiner asks.

    September 13, 2026Tax checklists and organizers

  89. Auto Bank Reconciliation in Excel With Matching Formulas

    Set up auto bank reconciliation in Excel with XLOOKUP and COUNTIFS so book entries match bank lines on their own and only the exceptions need your attention.

    September 13, 2026Statement reconciliation

  90. W-2 vs Final Pay Stub Year to Date: Why They Differ

    W-2 vs final pay stub year to date: why Box 1, Box 3 and Box 5 rarely match the last stub, which items cause the gap, and when the difference is an error.

    September 13, 2026Tax forms, W-9s and payroll paper

  91. Missing 1099-B: Finding the Brokerage Figures

    What to do about a missing 1099-B: where the brokerage figures live, how to get the consolidated statement, and what happens if cost basis is not reported.

    September 12, 2026Chasing missing documents

  92. Tax Workflow Software: What It Should Track

    What tax workflow software should track for a firm: return stages, assignments, due dates and documents, plus how to compare options without a sales demo.

    September 12, 2026Tax season workflow

  93. Accounting Firm Folder Structure That Scales

    An accounting firm folder structure that holds up at 50 or 500 clients: the levels to use, a sample tree, and where indexing replaces another subfolder.

    September 11, 2026Sorting and organizing client files

  94. Missing 1099-R: Finding the Retirement Payout Figures

    What to do about a missing 1099-R: asking the plan or IRA custodian, reading the account records, and using Form 4852 when the form never comes.

    September 10, 2026Chasing missing documents

  95. Invoice Line Item Extraction for Multi-Page Invoices

    Invoice line item extraction step by step: reading item tables, handling multi-page invoices, and checking that line items add up to the invoice total.

    September 10, 2026Receipts and invoices

  96. Household Employee Tax Checklist for Nanny Employers

    A household employee tax checklist for clients who pay a nanny or caregiver: wage records, the W-4 and I-9, state filings and the W-2 the family must issue.

    September 8, 2026Tax checklists and organizers

  97. Income Statement to Excel With Periods and Subtotals

    Move an income statement to Excel from a PDF or report export: monthly and year-to-date columns, signs for expenses, subtotals and a net income check.

    September 5, 2026Ledgers and financial statements

  98. Financial Spreading Software or a Spreadsheet?

    Financial spreading software compared with spreading in a spreadsheet: standard templates, multi-period input, ratios, loan files and when each one fits.

    September 5, 2026Ledgers and financial statements

  99. AI for Accounting Firms: Where It Helps in Tax Season

    Where AI for accounting firms helps in tax season, from reading documents to drafting client emails, and where a CPA still has to check every answer.

    September 5, 2026Tax season workflow

  100. How to Reconcile QuickBooks Online Bank Accounts

    Reconcile QuickBooks Online accounts against the bank statement step by step, read the difference figure, and undo a bad reconciliation without losing work.

    September 4, 2026Statement reconciliation