Strong expertise in Bookkeeping and reconciling Trial Balances.
Cleaning up and organizing substantial amounts of data extracted from QuickBooks in Excel using advanced formulas such as VLOOKUP, Pivot tables, and checking for duplicates.
Familiarity with complex QuickBooks functions including Pay Check, Employee payroll setup, Item list, Payroll item list, applying ‘customer payments with invoices’ and ‘deposits with customer payments’, clearing undeposited funds account, and applying bill payments with bills.
Ensuring accurate balances of Accounts Payable (AP) and Accounts Receivable (AR) based on imported data into QuickBooks.
Ability to identify errors in the import process and rectify them in Excel to guarantee a smooth and error-free import of QuickBooks data.
Knowledge of GST, Tally, Income Tax, TDS, PF, and ESI.
