You are purchasing a Zip file which includes the Excel Template and the QuickBooks file. The QuickBooks file is the very file from the video which means it is done in QuickBooks Premier 2012. It will open in 2012 Editions of QuickBooks Pro, Premier, or Enterprise Solutions and newer. The Excel File was created in MS Excel 2010 and can be opened in older versions. 2003 Office users may need to download a free converter from the Microsoft website in order to open this file.
Read the original blog post on QuickBooks Excel Cash Flow and Technology
36 Minutes of video tutorial
Receiving deposits from customers is very common, so knowing the best way to handle them in QuickBooks is very important.
Keep your financial statements clean.
Maintain a system for tracking deposits that is easy to set up and use.
- Know how your transactions will affect your financial statements.
- Two ways to record a customer deposit and the advantages / disadvantages of each.
- Set up your “Customer Deposits” account on the books.
- Set up an item in QuickBooks for the customer deposit.
- Invoice your customer in QuickBooks for the deposit.
- Customize a report to track your customer deposits in QuickBooks.
- Think through how the transaction SHOULD affect your financial statements.
- How to figure out how to set up QuickBooks and post your complex transactions.
- Know how to record a journal entry to apply the deposit to the customer’s balance
- You will know how to run, customize, and analyze various accounts receivables reports.
- Set up your own report group in QuickBooks’ memorized reports and save your custom reports in that group.
- Two ways to apply credits to an invoice.
This video also explains some best practices in terms of how you want to present your financial statements to potential investors or creditors such as a bank.
You will have insights into how banks and investors will look at your financial statements and why it is so important to have them ready and clean at all times.