
Completed
Posted
Paid on delivery
I need a custom QuickBooks Online report that shows vendor payments for the entire fiscal year, organised month-by-month and grouped under each Chart of Accounts number so only expense activity is captured—no revenue lines at all. The workflow I have in mind is: • Build the custom report inside QBO, filtering strictly by expense-type accounts and drilling down by vendor. • Arrange the data so every account number appears as its own row (or section) with the twelve months displayed across the columns, plus a year-to-date total. • Export the finished result to a clean, well-labelled Excel workbook; this Excel file is the final deliverable I will use for analysis and sharing. Key requirements for acceptance: • One tab containing the raw export exactly as it appears in QBO. • A second tab with the same data pivoted or formatted for easy reading, subtotalling by account number and grand-totalling at the bottom. • Filters applied only by Chart of Accounts account number (no vendor-type or name filters beyond what falls under each account). • All figures tie back to QBO when spot-checked. If you are familiar with QBO’s custom reporting tools and comfortable shaping the export in Excel, this should be a straightforward task.
Project ID: 40542267
22 proposals
Remote project
Active 5 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
22 freelancers are bidding on average $152 USD for this job

As a seasoned financial professional with over 15 years' experience, I believe I am well-equipped to handle your project. Being proficient in both Accounting and Financial Analysis, I have a deep understanding of Intuit QuickBooks and its custom reporting tools that makes me the ideal candidate for this job. In the past, I have successfully built comprehensive financial models that are resilient and accurate and leveraged my Excel skills to create dynamic spreadsheets to facilitate data analysis. Thus, combining the two facets required for your project: your custom report in QBO and its export into well-labeled Excel workbook. Not only do I possess the technical expertise needed to complete this task flawlessly, but my experience of working on projects across four continents has honed my ability to adapt effortlessly to different environments and provided me with the valuable skill of simplifying complex information into easily understandable formats. Ensuring all figures tie-back is a non-negotiable requirement for me in whatever project I tackle; hence, you can be confident in the integrity and accuracy of the report. Lastly, as a self-motivated professional with an unwavering commitment to excellence, I will make it my personal mission to surpass your expectations and deliver not just any solution, but THE solution tailor-made for your unique requirements.
$200 USD in 4 days
8.6
8.6

Hi, I have carefully reviewed your project requirements and I’m confident I can create the exact QuickBooks Online report and Excel workbook you need. I am a CPA and CBA qualified accountant with over 5 years of experience in QuickBooks Online, bookkeeping, reconciliations, financial reporting, and advanced Excel reporting. I have built custom QBO reports and transformed exported data into management-friendly Excel workbooks using pivot tables, formulas, and structured layouts. I will configure the report to capture only expense-related vendor payments, grouped by Chart of Accounts number and organized month-by-month with a year-to-date total. After exporting the data, I will prepare a professional Excel workbook containing a raw QBO export tab and a second tab formatted with monthly summaries, subtotals by account number, and grand totals for easy analysis. Every figure will be reconciled back to QuickBooks to ensure complete accuracy, and the workbook will be clearly labeled, easy to navigate, and ready for sharing. I am detail-oriented, efficient, and available to start immediately. My goal is to deliver an accurate, well-structured report that meets your reporting requirements without the need for further adjustments. Please open the chat so we can discuss your fiscal year, Chart of Accounts structure, and timeline. Thanks & regards, Mussadiq Hussain
$80 USD in 7 days
6.9
6.9

I understand that you are looking for a Custom QBO Expense Payment Report that provides a clear, concise overview of your vendor payments for each month of the fiscal year. And I can assure you, as CEO of Systemapic, my team and I have extensive experience helping businesses optimize and automate their operations using softwares and tools just like QBO. Our expertise in CRM Automation, Workflow Automation, API Integrations, and importantly, Data Analysis and Visualization would be invaluable in creating a custom report that meets your precise needs. We are adept at working with QBO’s custom reporting tools and have a keen eye for detail which is necessary to accurately filter by expense-type accounts, vendor drilling-down, itemizing each Chart of Accounts number as unique rows or sections with 12 months displayed across columns plus YTD totals.
$250 USD in 7 days
5.4
5.4

As a multi-talented professional with vast experience in Data Analysis and Visualization, I'm well-versed in not only general Financial Analysis but also specific Excel-driven tasks like the one in hand. I acknowledge the need for an organized and easily comprehensible report, and through my proficiency with financial software like QBO and Excel, I can build a custom report tailored exactly to your requirements. I assure you that all figures would tie back seamlessly to QBO during spot-checks. Another strength I bring forth is my expertise with advanced Spreadsheet functionality, enabling me to deliver a second tab containing the same data, suitably pivoted or formatted for easy reading and analyzing. Your desire of subtotalling by account number and grand-totalling at the bottom would be efficiently met without any inconvenience. The final deliverable- Excel file- will be well-labelled and to the point for your ease of analysis, proportionate to your repots' needs.
$240 USD in 3 days
4.2
4.2

Given my professional background as a Chartered Accountant and Certified Public Accountant with over seven years of experience, I am highly adept at providing comprehensive accounting solutions, which includes creating custom reports just like what you require. My proficiency in Intuit QuickBooks and Excel is exceptional, which makes shaping, filtering, and exporting data seamlessly to your exact specifications a straightforward task for me. My specialization in managing end-to-end financial operations and ensuring accurate record-keeping offers the assurance you need that the figures in your expense payment report will confidently tie back to QBO when spot-checked. Furthermore, Utilizing my expertise in accounts payable and receivable management, I will not only create the raw export in one tab but also will pivot or format the data for easy reading in a second tab with subtotalling by account number and grand-totalling. Moreover, my role extends to offering streamlined accounting processes that improve operational efficiency—this is essential for your project's "clean, well-labelled" Excel deliverable that you intend to use for sharing and analysis. My thoroughness, attention to detail, and commitment to accuracy will ensure that your custom QuickBooks Online report is error-free yet contains every detail you require. Trust in me for a reliable solution that adheres perfectly to your business needs while supplying value-driven results.
$80 USD in 7 days
4.0
4.0

Hi, This is a task I can complete efficiently. I have experience working with QuickBooks Online custom reports and advanced Excel reporting, transforming raw accounting data into clean, analysis-ready workbooks. I’d be happy to share samples of similar financial reporting projects. I can: • Build the required QBO report filtered by expense accounts only • Organize vendor payments month-by-month with YTD totals • Export the data into a well-structured Excel workbook • Create a formatted summary tab with subtotals by Chart of Accounts number and grand totals • Ensure all figures reconcile with QuickBooks for accurate reporting My focus is on accuracy, clean formatting, and delivering an easy-to-maintain workbook with transparent calculations. I can start immediately and provide a quick turnaround while ensuring every figure ties back to your QBO data. Let’s discuss further details in chat. Regards, Taha
$140 USD in 7 days
3.3
3.3

Hi I will build a custom QuickBooks Online report that organizes vendor payments by expense account, month, and year-to-date, then deliver a clean Excel workbook ready for analysis. I reviewed your requirements for filtering only expense accounts, grouping by Chart of Accounts number, preserving a raw QBO export, and creating a formatted summary with monthly totals and grand totals. What you'll get: • Custom QBO report with accurate expense filtering • Excel workbook with raw and formatted summary tabs • Fully reconciled figures that match QBO records I'm a verified freelancer and I've completed similar projects with 5⭐ feedback for accuracy and delivery. Timeline: 2 days Bid: $80 Please send me a message so we can get started immediately.
$80 USD in 2 days
2.5
2.5

Traverse city, United States
Payment method verified
Member since Jan 13, 2026
$25-50 USD / hour
$25-50 USD / hour
$25-50 USD / hour
$250-750 USD
₹12500-37500 INR
$30-250 USD
₹100-400 INR / hour
min $60 NZD / hour
$250-750 USD
₹750-1250 INR / hour
$30-250 USD
$30-250 AUD
$8-15 USD / hour
$25-50 USD / hour
₹750-1250 INR / hour
₹12500-37500 INR
₹1500-12500 INR
₹12500-37500 INR
₹600-1500 INR
$250-750 USD
₹12500-37500 INR
₹600-1500 INR
$8-15 USD / hour
₹1500-12500 INR