Help clients on a monthly basis to reconcile bank accounts in QuickBooks Online (QBO)
a. Every two weeks verify all accounts are online and synchronizing data with QBO
b. Monthly verify that payroll is being recorded from QBO payroll or outside payroll providers like ADP (should be an import done by clients)
- Set up and adjust QuickBooks rules to automatically map bank and credit card transactions to General Ledger accounts
- Prepare and update amounts for monthly recurring journal entries
- Record expense reports
- Record adjusting journal entries when appropriate
- Prepare list of open items and questions
Bookkeeping Cleanup Clients
Inventory bank statements to verify that we have PDF copies of bank statements for each month associated with the period we are working onConvert files using Money Thumb softwareVerify that all transactions were converted properly into an excel spreadsheet by totaling the spreadsheet by month and comparing to the bank statement for deposits and withdrawalsBeginning coding / mapping the transaction into the appropriate accounting categoryPrepare a spreadsheet of open items that you are not able to code / map because of inadequate bank descriptions for the transactions that we will provide to the client to get the business purpose for proper codingPrepare a spreadsheet of all check activity that we will provide to the client to get the business purpose for proper codingUpdate spreadsheet with client responsesCopy the transactions that have been coded into our Profit and Loss template spreadsheet that has formulas that will look up the coding / mappings to summarize the information into a financial reportRequirements :
B Com, M Com, MBA Finance, CA-inter, CA or any equivalent degreeMinimum 3 years experience in handling bookkeeping and accountingGood English written and verbal communication skillsExperience in QuickBooks is an added advantageKnowledge of accounting fundamentalsSkills Required
quickbooks online , Journal Entries, Bookkeeping, Financial Reporting, Excel