I'd like to share a story on how I became involved with A2X. It all started after I took a phone call from a prospective customer who wanted a new bookkeeper. This customer was already using Quickbooks Online and had a growing Amazon FBA seller's account. Immediately I became intrigued to see if I could find a way to guide them to success navigating around the Amazon settlement reports using QBO. Since that phone call, I have been on a journey of learning Amazon FBA bookkeeping skills! At first, I thought to solution would be to export the transactions from Amazon to Excel then run a PivotTable in Excel and then manually enter the sales [...]
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.