QuickBooks Q&A

Original commenter did not share additional details

Has anyone attempted to pull a report/data table using excel/ODBC driver to get inventory by bin location similar to the report in QB Enterprise? Example: The "inventory by bin location" report in quickbooks is a great report. However, it's not easily customizable, and even more so, in excel when you export the report. So, i am trying to pull this data into excel using the ODBC and microsoft query. However, I can't seem to find a table or multiple tables to use when performing the query. I.E. the "itemsite" table doesn't actually provide quantity on hand at all. the "itemInventory" table pulls in company-wide quantity on hand. We have multiple locations, and any inventory part might be in multiple bins/locations within that geographical location. So, is it possible to create a report or data table using this method to have matching data? I.e. i want my table to show the exact same quantity on hand for a given bin/location as quickbooks shows me in it's internal reporting.&nbs

I'm getting an error message that QuickBooks allows five levels of accounts. I need to have a few more levels. (e.g. Materials: Change in Inventory: Purchases: Raw Ingredients: Chocolate: Baking Stick). Does anyone know if there's a way to override this?

Original commenter did not share additional details

Original commenter did not share additional details

Original commenter did not share additional details

Original commenter did not share additional details

Original commenter did not share additional details

Original commenter did not share additional details

I would like to have the tax show up after profit line, before net profit.  Right now, it shows up alongside other operating expenses.

Original commenter did not share additional details

When running a report, the feature to narrow a column no longer works.  Is that a change in Quickbooks?

I am in Canada.  I get invoices from Fedex which are only for GST when I import product.If I want to input it as an Expense since the Courrier Expense is $0, I cannot input it as an expense.If I input it as a Journal Entry, then the GST is not records in the ITCsAny suggestions on how to input it.

Hello, I used the automation within QBO to prepare file and pay my HST, however the payment shows as a Credit not a Debit in the Bank Transaction listing.  I am not sure how to fix this as I have already tried to delete and readd the payment.  Please see attachment. ThanksNicole 

We have both actual employees, and a staffing agency that we use. For the staffing agency, I e-mail them the hours each pay period. I have the staffing agency set up as a vendor. Is there a way to automatically include the hours as part of labour?

I have wound up an idle opco, owned by my holdco, which had money owed to my holdco that will not be repaid. I filed a t2027 to report this, but need to know how to record the process in quickbooks to clear the "Due from Related Company" amount from my holdco's ledger.

We are experiencing constant cost increase for most parts we purchase and it is a lot of work to manually correct sales price every week to follow the set markup of 30%. In many cases, items have been sold at below cost due to this bug. Is there a way to automate this in QB desktop Pro? Will QB issue an update to correct this? Why isn't the sales price adjusting to the set 30% markup?

Original commenter did not share additional details

 Hello All, HST payment: - Generally I record HST payment in Quickbooks online and and for actual payment I cut a check to CRA, and go to my Bank to pay the amount. Few weeks ago, in my QuickBooks online I saw that QuickBooks online has new feature for  HST payment - that QuickBooks can pay HST directly from your Bank account and pay CRA, there is no need a cut a check . I called support centre, the agent was not aware of this new feature. According to the agent this feature is not available yet. And I searched in online, could not validate this feature. Now, I must have misunderstood. Unfortunately I have not print out that information, so I am recalling from memory only.  Can some one please validate / verify this feature. I will be waiting for replies since today (05-31-2022) is the due date of my monthly HST payment.   Thanks Farzana 

Original commenter did not share additional details

Original commenter did not share additional details

I just recently purchased the download version of Desktop Quickbooks Pro 2021 for a custom product that we sell.  I have already set up the Inventory under the Inventory Part that we sell and had on hand at Dec 31, 2021.  After more research, I see that it should of actually been done under the assembly tab.  However, that option is not there.  The only options available is to add a Service, Inventory Part, Non-Inventory Part, Other Charge, Subtotal, Group, Discount and Payment.  How do I go about getting the Assembly option?

Original commenter did not share additional details

Hi, I recently started a business and wanted to use your software. I made an account on quick books online via my pc, and I was going to get the essential plan but I got side tracked. Later I installed quick books accounting on my phone thinking it was the same thing and started the trial, went to use the pc and checked the account on there, it said I was on the starting package. I wanted to switch over to the essential package but it wouldn't let me saying I was on Google billing. I looked all over the web page account settings, quickbooks account settings, billing and subscriptions and I found no option to change it. It just says "looks like you're on Google billing". I checked Google play store AND the Google play website and I did not have any active subscription or trial on any. I want to use this on my pc and I can not switch the plan, or billing, or anything. 

Does anyone know how to record a non-taxable deduction from an employee? This is a non-taxable deduction that needs to be deducted from an employee's net income (very similar I guess to a garnishment situation)