Reports and Accounting

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?

All of our fixed assets are fully depreciated, they have a value of zero. They are appearing on the balance sheet with a balance of zero. Is there anyway to have them taken off the balance sheet? I know that you can customise the report to show non-zeros but ideally I want them automatically gone as they have no balance?

No text available

I'm trying to reconcile my paypal accounts with no luck, there appears to be duplicate transactions in my chart of accounts for each sale. For example this customer spent £33.96 today and paypal took a fee of £1.28. Whilst the fee is only appearing once, the sale itself is appearing twice. This is the case for every single transaction made. How do I fix this error and avoid it happening again in the future? Thanks!  

Sales by Product/Service Summary  If you run a report of an individual product that will show data, but if you download the overall report it misses many details.Inventory Valuation Detail. This is averaging out and showing data of only available products I need the Last Cost of all products, Regardless it's available or not.

Hi all, I am having real trouble with invoices sent to one particular customer . She has now reported twice that she has not received my Quickbook invoices. Previously she had no problems receiving them.  They have not gone into spam folders, neither of our emails have been changed.  This had caused her to be late in paying the first invoice which failed to be sent. The second time, we were on the alert. In my list of invoices sent out, it records the invoice being sent out to her but she has definitely not received it.  I am aware that this has been an issue in the past. Please can someone clarify ?? Digital accounting was meant to simplify my book-keeping and tax affairs but  I feel that Quickbooks has breally let me down in this way. TIA

Dear all,I'm trying to understand how to compute the unrelieved loss (with a specific example) when there is an R&D claim and how to record it. Would be very grateful for some kind help. I read S1056 from https://www.gov.uk/hmrc-internal-manuals/corporate-intangibles-research-and-development-manual/cird90500 which defines the unrelieved loss in this circumstance. Take the following concrete example: ==== EXAMPLE DATA ====Loss per accounts: 20000Amortisation: -15000Enhanced R&D expenditure: 80000 enhanced at 130% = 104000Capital allowances: 100000=> Trading loss: 209000 Total enhanced R&D expenditure: 80000 + 104000 = 184000 This company is putting in an R&D claim. The tax credit (tax relief) that could be obtained by making said claim is 14.5% of the Total enhanced R&D expenditure, i.e. 184000 @ 14.5% = 26680==== END OF EXAMPLE DATA ==== Unrelieved loss: My understanding is that the unrelieved loss