You are invited to my Quickbooks Online webinar on Nov 29th from 11:30-12pm CDT. I'll be teaching on the how to setup and use the bank feed rules. Register here to receive an invitation to the Zoom meeting link.
A common mistake in the bank feeds is to click the add button for income instead of matching a customer payment. This mistake could lead to overstating income on your P&L report. If you are using invoices or sales receipts you will want to match the receive payments by your customers. If you find that you are adding income in bank feeds by clicking the add button then there will be an open invoice associated with the customer. Creating an invoice means you need to have a receive the payment associated with it. Alternatively, you can use sales receipts to recognize customer payments on the spot. Below is a screen shot of the bank feeds [...]
The Audit Log will report all activity with a timestamp on the user who performed the transaction. An audit log report could show you when and who voided or deleted a transaction from the register. It also could let you see if a transaction changed from a reconciled status to un-reconciled status. Access the Audit Log by clicking on the gear icon which is located in the upper right corner then click Audit Log from the tools menu. You will see the following headers: Date Changed User Event Name Date Amount History A special trick that I like to use is the filter button to view all voided/deleted transactions. Click the filter button then check [...]
The Profit and Loss report by month is an insightful report that sheds insight on monthly income or losses. As as small business owner, this report can help you understand which month was your highest net income month. It also can report which month had the greatest expenses. Knowing your income by month will help you create budgets and have a greater clarity of how your business operates in a yearly cycle. You may wish to collapse the report details by clicking the arrows next to Income, Cost of Goods Sold, and Expenses.
The Profit and Loss report by Customer (aka Income Statement) will display your income, expenses and net income (profit or loss) by customer. Like the regular P&L report, it will be based on a starting and ending period of time. You can access the P&L by Customer by first clicking Reports on the left navigation bar. Then scroll down and select Profit and Loss By Customer which is in the Business Overview section. You can also find it in the search bar by typing "profit" and then selecting the report from the pop up list. This report will help you understand a clearer picture of income or losses by customers.
The open invoices reports in QuickBooks Online displays a list of all customers that haven't paid in full. This report will link to the Accounts Receivable of the Chart of Accounts. A common mistake for small business owners is to forget the past work they performed for their customers. The may have sent an invoice out to a customer but got so busy serving other customers they forget to collect payments. A business owner who is not organized in collecting customer payments in a timely manner will threat his own chances for existing. The good news is that QuickBooks Online will not forget which customers still have invoices not paid in full. To run the [...]