Reconcile balance sheet accounts—employee A/R, due to/from, prepaid expense, accrued expense, buyout payables accrual, leasing prefunding, line of credit, etc.
Do month end closing journal entries for depreciation, prepaid and accrued expenses, payroll accrual, franchise taxes, CPA, property taxes, commission accrual
Review unapplied accounts inventory receipts, payments to vendors, undeposited funds and unapplied receipts
Inspecting income statements to ensure all recurring expenses are entered and in the correct months. Create journal entries if needed to move to the correct period.
Prepare weekly Partners playbook which involves excel skills with pivot tables, v-look-up and formula experience.
Reconcile monthly bank settlements.
Prepare and file sales tax returns.
Prepare rolling 12 with look for missing expenses re-occurring such as rents, utility, commission accrual for any not paid for deals booked in the month; Any variances in expense accounts should be reviewed and explained. For example, hired 5 new reps advertising is increased by $1000 for business cards
Weekly cash flow report forecasting for the next two weeks of cash needs
Any financial projects/reports needed for the Partners. Such as pulling reports to submit to the banks, creditors for loan compliance or establishing a line of credit with vendors.
Prepare and present monthly financial statements for the partners.
Requirements
Excel a must with an emphasis on pivot tables, v-lookups and formula knowledge