Supported day-to-day bookkeeping by tracking customer invoices and payments, reviewing vendor bills and expenses, keeping records organized, and helping maintain accurate accounts receivable and accounts payable activity in QuickBooks Online.
Small business owners: your books don't have to be overwhelmed.
I'm building Balanced by Ash to help small businesses keep their bookkeeping organized and up to date.
I can help with: Quickbooks online bookkeeping, Transaction categorization, Bank and account reconciliations, accounts payable and receivable, invoicing, data entry and bookkeeping cleanup, basic financial reports.
I'm QuickBooks trained and Intuit Bookkeeping certified, and I'm currently taking on small freelance bookkeeping projects.
If your books need a little organization-or you have bookkeeping work that's been sitting on your to-do-list-I'm available for project-based work.
The project automates the Accounts Payable process by consolidating separate financial data files.
Using Excel’s VLOOKUP function, it links a central summary sheet (AP_Summary.xlsx) with two source workbooks to automatically fill in missing information. It reads the Vendor ID to pull the matching company name from Vendor_Master.xlsx. It reads the Invoice Number to pull the correct billing total from Invoice_Register.xlsx. This process eliminates manual cross-referencing, cuts down on data entry errors, and instantly creates a unified financial dashboard for efficient invoice tracking and accurate bookkeeping.