How do you match a deposit to a receipt when the credit card refund is more than the actual deposit
Example: We received a credit card payment from customer A ($334.00) and sent a credit card refund ($1,000.00) to customer B on the same day. This resulted in a net negative deposit ($666.00) from our credit card merchant provider. How to match a refund receipt and a regular receipt to properly match the deposit in […]
How to create Sales by Customer Detail report that only shows one line per item invoiced
Sales by Customer Detail report (screenshot 1) is for both income and COGS for inventory items (screenshot 2). That’s why the report is showing positive and negative numbers. To show one line per item in essence for income only, you will need to customize the report. Click the customize button > Go to Lists section […]
How to see daily income in total?
You can customize daily income in total and make this your own customized Flash Report for your business. From the home page screen Left Navigation Bar Reports All Reports Business Overview Profit and Loss Change Transaction Date to “Today” Select Customize button (upper left corner) Change Accounting Method to “Cash Basis” if you just want […]
I need a report that shows product sales along with product cost so that I can see profit or loss for each product.
See attached screenshot sample report. You can generate this report directly from QuickBooks Online Plus with some customizations. If this is the type of report, you are looking for, you will need to take the following steps: From the home page screen > go to blue navigation bar on the left > select reports > […]
How to customize an expenses by vendor detail report in new QuickBooks Online?
Run built-in standard Profit and Loss Detail Report and customize it get expenses by vendor. To Profit and Loss Detail Report: From the home page screen Select blue navigation bar on the left Select “Reports” Select Go to report (small magnifying gals icon) and type “Profit and Loss Detail” Select Profit and Loss Detail from […]
How to run a cost of sales (COS) report in new QuickBooks Online?
There is no standard “COS” report you can run in new QuickBooks. But, you can customize standard P&L report and get the same results. To customize P&L and get COS (referred to Costs of Good Sold in QBO): From the home page screen Go to the blue navigation bar on the left Select Reports Go to report […]
For the purpose of auditing I need to export my entire list of fiscal year expenditures from QB online. What specific report will I run?
For this task, you will need to run the “Profit and Loss Detail and customize the report. GO to blue navigation bar (located on the left) •Select Reports •Go to report and type Profit & Loss Detail (see attached screenshot below for reference) •Select “Profit & Loss Detail” from the drop-down selector •Run Profit & […]
How to create a profit and loss report for selective accounts from our chart of accounts. Can this be done in new QuickBooks Online?
Let’s say in this example, you want to run profit and loss report for only two specific accounts from the chart of accounts: Sales of Product Income and Costs of Goods Yes, you can pull P&L report for those two accounts only in QuickBooks Online. Here’s how to start from the home page screen: Click […]
How can I run a report that gives me the detailed automobile expenses for this year in new QuickBooks Online?
Run Transaction Detail by Account and customize the report to show just Automobile Expense account. Select the blue navigation bar on the left Select Reports Go to Report (magnifying glass) and type Transaction Select Transaction Detail by Account from the dropdown selector list This report will show all transaction details by all accounts We will […]