Reports and Accounting

I want the settings for all reports in the company to be: - hide non-zero rows - show -ve numbers as red in brackets I know I can customise each report individually. Can I set this for the whole company as the default? Also how can I tidy up the formatting? QB displays each row as #,###.## format and each total as £#,###,##. How can these be formatted consistently?

No text available

When I run an aged creditors report, I get small balances against some of my suppliers.These balances are not visible on the individual supplier detail.This problem is in QB Desktop and I use multicurrency. Can anyone help?  

Hello.   I created a custom field in our customer records, basically adding the QBID number so I can dump reports from QBO and combine with another system we use.   When I run a Sales By Customer Detail Report, the custom field results are sporadically populated.   Not sure why its not populating 100%.  Anyone experience this problem?

Does anyone know if its possible to get the trial balance to report in a single column rather than two (debits and credits) Thanks

Hi,Thanks for reading, Is it possible for me to use the snap Receipt feature to upload z reports from my till for me then to attach to the daily sales template? Thanks.

Hello,I am facing two problems,1. I cant generate running balance in customer balance report as shown in figure attached.2. Secondly as a solution provided by you guys now I am using balance sheet and then i got to debtor (Receivable) and customize it as per my need to see running balance of my customer. But now the problem is I created a Journal entry and is not visible. Please help me in both of the reports.Customer balance report: cant see running balance from start.Balance Sheet Transaction Report: Cant see journal entries but is visible in customer balance report.   

I had a US dollar bank account which is now closed and, hence, has a zero balance in real life. In the sterling balance sheet, it shows up as c.£20,000. Can anyone help me correct this?  I can do a Journal Entry to take to zero but this would leave the account with a -$26,000 balance (albeit with the sterling balance sheet looking OK) Thanks Charles QuickBooks Pro 2010

During my first year of self employment, my parents gave me cash injections. Sometimes these were loans that I paid back, other times they were simply gifts (capital fronted?) to sink into my business. I've just switched my accounts to quickbooks, and synced my paypal and bank accounts, and there seem to be limited options for how I can categorise these transactions. I have a couple of questions 1) How are personal/family loans transactions reported to HMRC during self assessment? Likewise, what about free cash injections? 2) For the sake of quick books self employed, under which category do I mark these? If I mark them as 'personal' I think they'll be excluded from the assessment altoghether. But 'Business income' doesn't seem right either. I'm sorry for such a newbish question Thanks in advance :)

Hello,I need help. I have customer who is my vendor as well. the problem is I cant create a report where I see both in a single ledger along with a net balances. It is very alarming not to know what he owes me and what i have to pay. please help with the best solutions available.

Hi, Either I am not doing something right, or I think there is a bug in the way QBO handles Classes, specifically in the reporting of Cash Accounts on the Balance Sheet.  Once I have Classes switched on then I have to specify a Class in every transaction, which I do. Say I make a £100 expenditure from my current account and charge that to an expense account called Food, and I tag that transaction with Class General. My P&L report will correctly show an expense against category Food and will tag that transaction with Class General. But when I run the Balance Sheet, with a column for each Class, the reduction in the current account balance will not be shown in the General column, but in an Unspecified column.  (The equivalent thing happens with income accounts too.) To sort this out I have to do multiple journal entries at the end of each month in order to clear out the Unspecified column and get the correct values into the correct Class columns. A real hassl

Hi there, If I have an estimate with say 10 product/lines and each of those product lines are from a different vendor. When I change the status of the estimate to 'accepted' and then 'copy to purchase order' shouldn't quickbooks create 10 new purchase orders for each vendor I need to send a P/O to?  instead I get 1 Purchase order with all ten product/lines?  If anyone can help it would be amazing.  There doesn't appear to be any tutorials on it after searching You Tube and also Quikbooks website. Many thanks-Paul

In one of my companies the P&L report doesn't show the line Gross Profit, Just Total income, how can I rectify this please?

Hello everyone. I have a subscription with QBO Plus UK edition and I am looking for the Custom Summary Report feature of which I cannot find in the company. Is there suppose to be this feature? Also, with our external accountant (QBO Accountant) he has this feature on his company.        I have seen that of the QB experts mentioned that it is available - or might be referring to the international version? I'd appreciate if someone can point me on the right direction. Thank you.         

Hello- need some help with my "Open Invoice" Report. When I pull this report it prints some customers showing a "0" dollar balance. I onl

Accounts payable report is correct but the open balance in supplier account is different?

I have read through all documentation there is on opening balances to try make sense but some things are still not clear: We have 2 bank accounts, one with o/b of zero on 1/10/2018 and the other one used since Mar18. We started using QBO only when the first account was opened, in Oct18 so the first transactions are from Oct18. How do I manage all previous expenses on the 2nd bank account, which were not yet in QBO? So far I also added an o/b 1/10/18 for the 2nd account. In the 2nd account we have initial capital, directors loans and asset expenditure prior to Oct18 so I created an opening balance for 1/10/18 for the Bank Account and the Loans (I went and did it on the Chart of Accounts). I wanted to do the same with Shareholding capital and Fixed assets but also put Admin expenses as a lump sum ending/b of all previous expenses into a "miscellaneous expenses" account (this is historical data so not relevant).  Would I use the retained earnings account perhaps a

No text available

Why does the journal report shows the paid amount twice. Attached the pic of the report for your ref

No text available

Hi, Would really appreciate some help with this. My understanding is that Quickbooks uses FIFO for Cost of Goods and it's based on actual sales and expensed as each product is sold. Am I correct in my understanding? All of the guidance I can find uses the formula Beginning Inventory + Purchases - Ending Inventory I would prefer to use actual sales to track Cost of Goods as this seems a much more simple way of doing it. Many thanks

No text available

Is there any way of paying more on a monthly basis to have more than the 40 active class items in QB online? If not, can anyone recommend an add on which works alongside QB that could be used?

No text available

I am trying to delete old current assest accounts from the chart of accounts as we haven't used them in years and they have a balance of zero. They are never going to be used again. When I try I get an error message saying "This account cannot be deleted because there are unbilled charges for this account" Can anyone help as to how to delete the account/what it means when it says there are unbilled charges for this account?