Keeping track of your monthly sales is a great way to compare the health of your business as time passes. I'll help you find ways to show this information when using QuickBooks Online.
Based on your question, it sounds as though you're not recording each sale you make into QuickBooks Online, but rather you're tracking a total sales amount in Excel. If I'm understanding you correctly, you'd like to simply upload this Excel document into QuickBooks Online in order to produce a monthly sales summary.
At this time, QuickBooks Online requires you to enter individual transactions, such as invoices and sales receipts, in order to produce a monthly sales summary. Once this is done, you can run reports such as the Profit and Loss, and Sales by Product/Service Summary Report to display monthly sales. Each report can be filtered by specific dates by adjusting the reporting range at the top of the reports page.
I hope that helps clear things up for you. If you have any other questions, please let me know.
Have a great day!
QuickBooks Online allows you to import different types of data from Excel, reducing manual entry and saving you time. I can explain how to import your invoices into your QuickBooks Online company.
Here are the steps to import your invoices:
I recommend reviewing our Community article Import multiple invoices at once before beginning for further details on preparing your spreadsheet before importing. You can also check out Common questions about importing data to QuickBooks Online for more information.
One thing to note is that this process allows you to import open invoices, and there isn't an option to import payments or sales receipts. However you can connect your bank account to the bank feed within the Banking tab and import the payment transactions. You can then match them to the imported invoices to close them as paid once again. You can learn more about bank feeds here.
Please let me know if you have any questions regarding this process!