Reports and accounting
Recently active
Up to about a week ago, I was able to run a Purchases by Product/Service report and filter it to the customer I'm invoicing, so that I have a compact simple list to cross-check purchases with estimates, and accurately bill my clients. A week ago Customer disappeared as a Filter. Is this an error--is it coming back?This is an obvious field for reports sorting, not something obscure I'm trying to filter on. I don't understand why Quickbooks Online processes and features that are helpful and working suddenly disappear with no notification. I don't understand why there's no accessible change log that tells us what has been changed behind the scenes as it happens. I just don't understand.
Original commenter did not share additional details
Hi- I'd like to run a report that shows all expenses from May 2023 to July 2023. I need it to include a Tags column (whether a tag was used or not) so I can make sure all expenses were properly tagged and that I did not miss any. Which report can show that information?
Normally when I purchase a product for resale, my vendors do not add tax. I then add my markup and applicable taxes for the resold amount before invoicing the client. I recently purchased a product that I intend to resell but my supplier withheld taxes on the COGS amount. Once I add my markup and figure the taxes on the full sale amount, I need to decrement the taxes due by the amount that I paid my vendor. The only way I can figure to do that is to have two line items on the invoice. The first is the COGS amount with no taxes applied and the second is my markup with tax applied. But then I give my client visibility into my margins. Is there another way to do this without giving the client that visibility?
Hey there,I have an expense for some items I bought for my business. I paid for the items and want to reimburse myself eventually. So, I scanned in my receipt. The receipt was read properly. I then went to review the receipt. I split the transaction across the relevant categories. Then I chose my owner's investments equity account for the payment account. Now I cannot save and close the receipt.I have found a workaround that annoys me to no end. I have changed the Payment Account to my bank account and added a split for a negative line item to the equity. Now, I have a $0.00 transaction in my bank account journal. Even more annoyingly, I have to deal these zero'd out transactions at reconcile time. This seems like a very bad UI. Is there a better way to setup my owner's investment account so that I can directly post payments to that account? I would still like to take advantage of scanning in my receipts and having the transactions created from the information on the receipt. Or m
Is there a way to generate a report to show all invoices for all customers that have a partial payment on them, with the original amount and the amount paid on that report? Thank you
We do mostly Time and Material projects for customers in QBO. These projects might take weeks or months. We might have hundreds of expenses ranging from a couple of dollars to hundreds of thousands of dollars. These could be fuel purchases, hotel charges, supply purchases, and some flow through Purchase Orders and many do not. We use Projects inside QBO and we mark all expenses and purchases as billable and assign them to their respective Project. So far so good. When we invoice the customer, we use only a few line items to capture all of these costs into categories such as Parts & Equipment, Consumables, Rentals, Travel Expenses, Contract Labor, etc. We do NOT list every individual expense on the invoice which would result in dozens of pages for each billing. That would be insane and our customers do not want that, nor do we. Currently, we run reports for all expenses related to a project, then add these totals to the line items on the invoice manually. Unfortunately, th
I have two classes set up in Quickbooks Desktop: 148 and ARPA, the latter being restricted federal funds. I just learned that about $5000 of one employee's payroll costs from the past year needs to be changed from Class 148 to Class ARPA. I could do this by going into the individual journal entries for payroll and splitting out pieces of her wages into the separate classes, but this would be very time consuming. I'd rather make a journal entry (or so some other magic) to change the class on $5000 of her wages for the year. The expense account of course needs to remain unchanged. Any way to do this? Thanks in advance.
According to the QBO resources, there used to be a simple way to record refunds and then link an unapplied payment to the transaction. That seems to be long gone. Let's say the customer paid $3000 by credit card over a month ago as an unapplied credit. That amount needs to be refunded. Creating a Refund Receipt creates a CREDIT on the account. So now the customer records show $6000 credit. Where is the simple transaction that will create a DEBIT that can offset the original credit leaving the customer with a $0 balance?
Hi QB Team, Well, I’ve made a lot of progress towards creating my first invoice. At the “all sales” page in QB Essentials, I have created about 55 time charges and 2 invoices. It looks like QB will scoop up all of the time charges and add them to a new invoice. I assume that it will leave the 2 existing invoices alone? My concern is that it took a lot of time to do all of that data entry and I don’t want to hit the wrong button and lose everything or have it stored in the wrong place and I can’t reverse it. Is my data backed up?Can I roll it back to a previous state?Can I add my time charges one-by-one to an existing invoice so that I can see what is happening step-by-step? Thanks, tclark47988
I ran my 1099 Detail report. I have 3 vendors that I paid airfare from the business and they each paid me back. I know this is messy, but can you help me fix it? Vendor #1(M) - I entered her expense as a bill and paid it with a check referencing the Job. She reimbursed me via Zelle, which went to my personal bank account. I left that reimbursement in my personal bank account. I entered the credit in QB as a Journal Entry (debit Petty Cash/credit Customer COGS referencing the Job). Vendor #2(T) - paid her via iWallet from my personal account. I entered the expense in QB as a Journal Entry (debit Owner Contribution/credit Customer COGS referencing the Job). She reimbursed me via Apple Wallet to my personal account, and I transfered that reimbursement to my business account. I entered the credit in QB as a Journal Entry (debit business bank account/credit Customer COGS referencing the Job). Vendor #3(L) - I enter
Is it possible to expand a P&L report to not just show the subaccounts but each transaction under each account/subaccount?
If I open a bill or check from the Vendor Center it auto-fills the bill or check with the highlighted vendor. Is it possible to stop this from happening? I know it's a minor thing but it can be quite annoying.
I'm trying to print a report that includes the customer company name. I've tried adding it to the "other 1" field but it doesn't populate when I include the column in the customize report. I can get the company name in the Customer Contact list but it only shows partial. Anyone know how to get the report for ALL customer?
The damage was to common area items, nothing was a capital asset. We intend to replace what was damaged. How to post the loss?
I need to be able to run a report for accounts payable by class to ensure the bills are being paid from the correct bank account. We are using QuickBooks online Advanced - any suggestions? Thank you
Hi, I have the basic Soloprenuer with QB online and can not locate the " tags" feature in settings. I have watched videos and it should be under the " list" column but I do not have that option either Do I need Essentials to have this feature?
Please fix with update
with the new invoice layout how can you do "send later"?
I need to run a report that filters down to just my inactive customers and see their sales for the year prior. One of our customers switched ownership and renamed with something very similar. They have 9 locations. To avoid confusion, we needed to make the old customer inactive. But now I would like to do a side by side comparison of last year's revenue to this with the old customer name and the current customer name, but I am not able to select the inactive customers on the filter list because they do not appear there. I cannot make them active again, so this is not an option. How to I make them appear as a selection under filter on my sales by class summary/detail report? I am using Quickbooks online.
