QuickBooks Excel Macro for Monthly Sales
Budget: $30 – $250 CAD
I'm in need of an experienced Excel Macro/VBA developer with a solid understanding of QuickBooks to create a tool to condense my QuickBooks monthly sales reports.
Key Tasks:
- Develop a user-friendly tool using VBA/Macro to automate and simplify the process.
- Specifically, The macro should focus on collapsing net sales base on invoice number, as well as separating shipping and Canadian taxes in separate columns
- The condensed report should include a detailed breakdown of invoice sales by sales representative.
The ideal freelancer for this job should have:
- Proficiency in Excel VBA/Macro programming.
- Comprehensive knowledge of Quickbooks reporting features.
- Excellent problem-solving skills and attention to detail.
- Experience in creating financial reports, particularly sales reports, is a major advantage.
The end goal is to have an efficient, automated system that will save me time and increase the accuracy of my financial reporting.
Key Tasks:
- Develop a user-friendly tool using VBA/Macro to automate and simplify the process.
- Specifically, The macro should focus on collapsing net sales base on invoice number, as well as separating shipping and Canadian taxes in separate columns
- The condensed report should include a detailed breakdown of invoice sales by sales representative.
The ideal freelancer for this job should have:
- Proficiency in Excel VBA/Macro programming.
- Comprehensive knowledge of Quickbooks reporting features.
- Excellent problem-solving skills and attention to detail.
- Experience in creating financial reports, particularly sales reports, is a major advantage.
The end goal is to have an efficient, automated system that will save me time and increase the accuracy of my financial reporting.