Reports & Accounting

I recently upgraded to QB online.  When I export a report from QB to excel, it comes up all zeros.  When I highlight the cell the amounts are there.  I clicked the box at the top "enable editing" so I know that's not the problem.  The file is not protected.  Can someone help?

No text available

Hi I import may daily sales to my quick book. Under imported transaction my  GST comes  under service item. How do I make a JE for changing  that from service item to Tax item for 1 month batch entries. currently I am going in each sales entry to edit it add GST tax item and remove GST service item.   

No text available

I would like to create a Customer Balance Detail Report for each separate customer. Is there a way to automatically run and save a separate report for each customer instead of having to filter the report manually for each customer and then saving down a pdf?

I deleted my reconciliation discrepancies account (by mistake). Now I cannot reconcile. I need to activate this account but QB wont let me. I have had 3 files opened with support and they say they resolve issue and close the file then i have to start from beginning again. Please help me. I believe i know what needs to happen, i just cant do it without back door support. Nicki 

No text available

I would like to create an expense report for taxes from the app

Hi.  I recently transferred my offline Quickbooks to Online Quickbooks.  In my offline version I had an account called Term Investments (all GIC investments) when I moved to online that account was transferred over but I also linked my bank accounts so now my GIC accounts are listed as they should be updating through online banking.  The issue is now my investments are duplicated in the balance sheet as they are listed in the "term investment' account as well as through the linked investment account.  Can anyone provide a suggestion on how to resolve the duplication of these accounts?  Ideally i would like to keep the GIC accounts that are linked through online banking.  Appreciate the help.

Is there a "go to" report for showing what QBO has recorded as actually been paid to a vendor? So a standard way of answering questions around what has actually been paid to a vendor/supplier over a period of time comprising which invoices, amounts, payment type, payment reference and when payment cleared (i.e., cheque cleared the bank) and even that payments' reconciliation status? I always seem to struggle/run into not having all pertinent information in standard reports QBO offers nor can I get a custom report done up properly and that I feel comfortable showing to decision makers, etc. Please let me know what you think! Steve 

Hello, The Transaction List by Customer Report would be very useful to me if I could customize it to include a list of POs.  It works great when I filter by a particular PO, but I want to see a report with only a certain list of about 10 POs.  Is there a way to do that?  I tried simply entering two PO numbers separated by a comma but no such luck.  -Thank you

No text available

No text available

We're a bitcoin based p2p platform and point-of-sale handling bitcoin expenses and revenue (locally, and in El Salvador), and our accountant has the conversion at sale/payment time for CAD, but she's trying to enter them as a foreign exchange payment which only does two decimal places.Because QuickBooks only does 2 decimals places instead of 8 for more detailed accuracy, she's been forced to use spreadsheets, and I'm afraid I'm going to be guillotined by my bookkeeper and accountant if we don't find a way to get them out of spreadsheets and back into quickbooks. Please offer an option for 8 decimal places and save a life :D

I have accepted accountant invitations from some students and cannot see them in my accountant teacher view. Is this something they did or something going on with my account?

Can you please give me a journal entry to post so that I can clear a fixed asset off of the Balance Sheet?  There was an old truck that was parted out but still shows on the balance sheet and I need to clear it off.   Im not sure which account to use for the journal entry. Thank you.

last years statements uploaded

I have two bank transactions that are bill payments to my landlord. However, the amount is different from the total billing amount so QuickBooks didn't match the transaction and I can't find a way to mark these transactions like bill payments to the specific bills. Now, these transactions look like this in my rents payable accounts. How can I mark them as partial bill payments? I don't want to create new transactions because I will have another problem matching my bank records. 

No text available

Can you get back deleted journal entries

Several bank accounts but all considered "personal" ventures. Client wants to be able to report on separate ventures (without having several QBO files), and record transfers between accounts. That is why I am looking for a solution to be able to create clean P

This does not work for me.  I do not see the 'edit work info'  link as in the picture.  Mine just has an 'edit' link which takes me to 2 questions about sales tax and GST.   Is there a different template in Canada?

HiI am looking for a way to "match" bills to invoices.I am aware that I can use the billable check box when posting a bill/expense but I'm not sure it's what I am looking for.We first invoice our customers and only after get the bills from our vendors. I would like to know if there is a way to enter the invoices and bills so I could later run a report and see what was a profit per invoice. Thank you  

we have a separate inventory system, so when I adjust the inventory to COG for sales as a JE it shows up on the report Sales by customer summary report. Any explination?

No text available