{"type":"video","version":"1.0","html":"<iframe src=\"https://www.loom.com/embed/3f816112fb044809a87688d3adb6215d\" frameborder=\"0\" width=\"1280\" height=\"960\" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>","height":960,"width":1280,"provider_name":"Loom","provider_url":"https://www.loom.com","thumbnail_height":960,"thumbnail_width":1280,"thumbnail_url":"https://cdn.loom.com/sessions/thumbnails/3f816112fb044809a87688d3adb6215d-1689054161422.gif","duration":388.562,"title":"Exporting Sales Data for Financial Year Reporting 📊","description":"In this Loom, I will guide you through the process of exporting sales data per month using Hungry Hungry. This will help you with your end of financial year reporting. I'll show you how to navigate to the download section, select a month, and open the downloaded file. We'll review the customer details, including their name, email, location, payment details, and order totals. I'll also explain how to filter the data to account for paid and refunded orders only. Then, I'll demonstrate how to create a reconciliation report and sum up the necessary columns. Finally, I'll explain how to calculate the net total by subtracting associated fees and refunds from the overall total. I'll also share a tip on creating a summary page and calculating the overall yearly net total. If you have any questions or need further assistance, feel free to reach out to the College mice early."}