Smarter Numbers, Brighter Future.
Revolutionizing Accounting and Finance with AI.
-
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…
-
QuickBooks Online QBO Tutorial for Beginners – August 2016
How would you like to learn QuickBooks in 90 minutes? This FREE video tutorial is specifically designed for beginners in mind. You will learn QuickBooks Online the right way from the start. It covers all the basics you need to learn and offers some helpful tips. If you are looking for step-by-step educational guidance and…
-
How to track donated inventory stock items by your business in QuickBooks
NEW!! QuickBooks Online Inventory Deep Dive These are the specific steps you can follow in QuickBooks Online (available in Plus and Advanced plans only) if you are donating or giving away tracked quantity of on-hand inventory items. Create ZERO Value Sales Receipt for Inventory Items: 1. From the Home Page screen > click Create (+)…
-
Handling Multiple Vendors Refund Checks Deposit in QBO
-
QBO Issues: Costco’s switch from American Express to Citibank Visa
Helpful articles Costco American Express has moved to Costco Citibank – Error 324 As of June 20th, 2016 Costco has ended their partnership with American Express and started a new partnership with Citibank. This impacts customers using Quickbooks Online and have their Costco American Express credit card connected to their account. Customer using the Costco…
-
QuickBooks Online File Size and Feature Limits
QuickBooks Online does not have a file size limit. However, if you enter huge amounts of data, you may experience a reduction in response times. Note for US customers only: For information on the limits of exporting desktop data into QBO, see Export limitations (US). https://community.intuit.com/articles/1145409-export-limitations For example, if you enter as many as 3,500…
-
Copy an Estimate to a Purchase Order
[huge_it_slider id=”4″] Video Tutorial:
-
From the Banking Center, how do I split a single expense transaction between two vendors
You will need to take the following steps in QBO if you need to enter a single transaction split between two vendors. In this example, the transaction amount is $11.23 and you want to split between two vendors (vendor A = $6.23 and vendors B = $5.00). #1 Enter manually those two vendors as a…
-
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 do I generate Income by Invoice report in QBO
Run Transaction Detail by Account report. Customize > Lists > Transaction Type = Invoice Distribution Account = All Income Accounts Change report title (optional) = Income by Invoice This customized report should show income by invoice. Filter for Invoices for the time period as needed. You can further customize the columns (add or remove) by…
-
Inventory Starting Value adjustment from Asset Register for Inventory Asset account
This new update in February 2016 may have resolved the crucial “Inventory Starting Value” adjustment issues. It’s very important to note that they release these new features to users on their incremental plan. Hope all users will see it soon. For adjustment, go to the chart of accounts > select Inventory Asset account > click…
-
What is the difference between “Paid” and “Closed” status on the Customer’s account page
Basically, you should see the “Paid” status once the sales transactions are complete involving Sales Receipt and Invoice forms. You should see “Closed” status when other steps are involved dealing with the Invoice. For Sales Receipt – it’s always “Paid” status. It involves a combination of the sales transaction and money received from that sale…
-
How to batch switch from service items to non-inventory parts without going into each individual item
You can batch “Change type” from service to non-inventory type or non-inventory to service in QBO. However, for service to inventory or non-inventory to inventory type, you can’t do batch change type, you will need to edit and change one item at a time. To make batch “Change type” from service to non-inventory type: 1)…
-
I have already received payments in QBO from multiple customers. How to make them match with a single deposit I see in my bank feed.
You’ve two ways to match with bank feed deposit. 1) Match it directly from the bank feed downloaded transactions. Select a row for deposit in question. The row expands to show you “Find other matching transactions” button. Once you click this button, you will see a long list of possible match transactions. To easily locate…
-
How to reconcile the Undeposited Funds account the same way like bank accounts
Currently, there is no option to reconcile undeposited funds account. The undeposited funds account is not on the listing of accounts that can be reconciled like for bank, credit card and other assets and liabilities accounts. Interestingly, it’s sort of automatically reconciled when existing payments from the undeposited funds transferred to the bank account. What’s…
-
How do I fix unapplied cash payment income and unapplied cash bill payment expense
You may see two accounts for UNAPPLIED cash payments if you report Profit and Loss on a cash basis. It will automatically trigger these two accounts simply because you have entered certain deposit and payment transactions differently than normal flow in QBO. These two accounts are automatically added to the Chart of Accounts when the…
-
How to use track return for customers field shown on deposit form
“Track returns for customers” have to do with whenever you invoice your client for billable expenses (time and material) and the client pays less (for a variety of reasons) than the invoice amount. This is a way to correctly track returns for customers’ accounts and receive payment to match the deposit amount. In case, you…
-
How to find out if the merchant credit card was processed and approved in the QuickBoks Payments merchant center
You can find out from the QuickBooks Payments home portal and select “Deposits” under Activity and Reports (see screenshot below). Once it’s approved, it usually takes 2-3 business days for deposits to show up in your bank account. To go to the QuickBooks Payment home portal: Directly from the QBO home page screen > Gear…
-
How do I add additional billable time and expense to an already created current invoice
In order to add additional unbilled time and expense, first open existing invoice. You can open it directly from the create + sign, select invoice under customers, and from upper left corner select invoice in question to open from the recent transactions. You can also open directly from the customer’s page under customers center. Once…