US Accountant

Accounting & Reconciliation Skills

• Strong understanding of GAAP

  : To properly treat cash receipts, deposits, and adjustments.

• Cash and receivables reconciliation

  : Ability to tie payments received to customer invoices, bank deposits (Authorize.net, Payment Tech, etc), and clearing accounts.

• Audit trail tracing

  : Tracking transactions from source (customer payment) through the ERP systems to the bank statement.

• Error identification & correction

  : Spotting duplicate entries, misapplied payments, or transactions sitting in undeposited funds too long.

• Journal entry preparation

  : Knowing when and how to record adjusting entries to correct balances for review and approval by Accounting team.

• Variance analysis

  : Identifying differences between systems and/or bank records and resolving them.

ERP & Systems Skills

• QuickBooks proficiency

  : Understanding how QuickBooks handles undeposited funds (as a clearing account) and how to clean it up.

• Sage Intacct expertise

  : Knowledge of Intaccts cash management and AR modules, including how receipts flow into deposits.

• ERP transition/migration experience

  : Ability to reconcile balances when data moves from one system to another.

• Data extraction & reporting

  : Exporting detailed transaction histories from both systems (CSV, Excel, custom reports).

• System audit logs review

  : Identifying historical posting errors, migration cutover balances, and system mapping issues.

Data & Analytical Skills

• Advanced Excel (or similar)

  : Pivot tables, lookups, and matching logic to reconcile large data sets over multiple years.

• Data cleansing & normalization

  : Preparing data from two ERPs into a comparable format for reconciliation.

• Bank reconciliation expertise

  : Ensuring deposits in bank statements tie back to cleared undeposited funds.

• Cross-system data mapping

  : Matching customers, invoices, and receipts across QuickBooks and Intacct (may require fuzzy matching logic).

• Attention to detail

  : catching small mismatches that can compound over multiple years.

Project & Soft Skills

• Attention to detail:

  Spotting small discrepancies across years of transactions.

• Patience & persistence:

  Reconciling three years of messy data is time-intensive.

• Documentation skills:

  Clearly recording adjustments, assumptions, and reconciliation steps for audit purposes.

• Communication skills:

  Explaining findings to management or other stakeholders.

• Time management & prioritization:

  Breaking the reconciliation into manageable phases (by year, by customer, by month).