Reports and accounting
Recently active
I understand that under cash basis accounting, and unpaid bill at the end of an accounting period will not affect expense accounts. However, it appears that the billed amount shows up in account 2000 on the balance sheet. Does this not cause the balance sheet to be out-of-balance if tied to the profit/loss from the income statement?
When I run a Sales by Item report, I get all the columns I need, but I cannot get it to show a column that displays the Manufactuer's Part Number. I need to see that column as well. Any tricks to display that? Thank you
Original commenter did not share additional details
I received Accountant's copy from a couple of clients and have discovered that they have made payments to folks that should be receiving 1099s. These people were entered as "other names" rather than vendors. Is there a way I can print out a list that would have the Others along with any payments received? Or, do I have to go through each one individually to see if any payments were made to them during the year.Thank you.Lynda
The screen shot below is from the Project Reports tab of a customer project in one of my client's QBO. The first three selections produce reports for just the particular project in questions. The selection below that under the "Report for all projects" heading gives a comprehensive report for all of my client's projects. This section does not appear in my own QBO Project Reports tab. Does anyone know why? I'm assuming there's a switch somewhere I need to flip to turn this on. Any help would be appreciated. Thanks.
I am having issues generating a custom report in Spreadsheet Sync. I get the message "Something went wrong. Try Again" Has this happened to anyone else and how did you fix. Also was it fixed right away.
Hello all, I am having trouble figuring out how to properly categorize a transfer made from a business account to a personal savings account. Thank you in advance for your responses!
Let's say I have a client that pre-pays $10,000 paid by check for pre-paid IT consulting service at the beginning of each year. So I create a Sales Receipt for $10,000 for the customer.Since this is a pre-paid credit to be applied later, then I create a Credit Memo for the $10,000.For the next 10 months, I Invoice the customer $1,000 monthly for my IT consulting service and then apply Payment for the Invoice from the Credit Memo balance. Throughout the year there will be other invoices for other sales and services to the customer with separate payments by check and credit card. I'm using QBO. I need a Monthly report to send to the customer that shows:The $10,000 sales receipt paid by check at the beginning of the yearThe $10,000 initial credit memoThe invoices for which ONLY credit was appliedThe applied credit memo payments for the invoicesThe remaining credit memo balance *** I don't want to show any other invoices or payments that are not related to the credit memo!&n
We have the DESKTOP version and I want a report that shows what our profit margin is by date combined with BY CUSTOMER. How do I find this report?
We have a customer that is a government entity that we had to assess late fees on a number of past due invoices in order to get them to pay. We have decided to forgive the late fees but are not sure how to remove them without affecting the P&L. They were assessed back in June and we need to remove them before the end of the year. QB desktop 2018.
I use the desktop version of QB and with the upgrade to 2021 I am no unable to drill down on P&L statements to get to the detail of the balances. It used to open a general ledger. Is there some setting that I changed causing this problem?
I am reviewing the transactions by vendors list. If the expense is paid by credit card, the expense shows up as a postive number. If the expense is paid by checking account, it shows up as a negative number. How do I fix this? A snapshot is attached. Thanks.
Here is my problem.I have trying to build an assembly. When I enter the assembly it shows the list of parts and quantities required to build this assembly. All good. When I enter the number of units, the quantities change to reflect the number of assemblies to be built. All good.I will not have enough parts; e.g. a shortage. So, I ask for a shortage report. I would expect that the shortage report will show a list of parts needed to build this many assembly items. Instead, I get a single item report showing my assembly item and the shortage required - not the list of sub-assembly parts required to build this many assembly items.What the? This has worked in the past. Not sure what changed or what I did wrong.Any ideas what is going on?Thanks,Phil PS> I am using the cloud-based QB Enterprise 2017 version.
I'm trying to use subcategories for expenses, and I can't find them when I try to categorize transactions.
We are wanting to make a purchase order that will populate all parts that are below reorder point for a specific vendor. Please advise on how to proceed.
When setting up an auto loan, do I include the amount financed or the total sale price including interest and taxes?
My current Officer Wages in QB shows $36,401.19 so far for this year but I need to report between $75k-$80k to the IRS for the 2024 year. Last year my accountant simply created a "paper check" in QuickBooks so that I didn't have to take the difference out in actual draws but it will be appropriately reported as taxable income to the IRS. They suggested I do this again this year to make up the difference but they wanted $190 to do it. I'm assuming this is a simple change in QB that I can do and save myself nearly $200 - I hope! If so, is it that simple and what steps would I do in QB? Also, do I need to account for other taxes or anything that is part of Officer Wages? For example, do I simply make a paper check for $38,598.81 (Gross Pay)? or do I need to take into consideration FUTA taxes that have been paid for the year, or is this already part of the Officer Wages being totaled for the year? Thanks in advance!
I am having trouble trying to find the best account to put loans made out to employees. Also, how to properly deduct loan payments from paychecks to where it will be recorded and updated to their actual balance. Is any of this even possible?
We have multiple employees working on several projects. With the new invoice system, I am no longer able to select all billable hours on a project. I have to click on each employee, for each day of the billing period. This will make my invoices 15 pages long!
Our church has a loan. It happens to be no-interest, which should make accounting easier. We use a P&L Budget to report on Budgeted expenses vs. Actual expenses through the year. One of the obvious expenses is the payments on this loan. I've set up a Long-term Liability account as the QBO Help says to do. I have found Help info that says you can add the Liability account to your budget, however, that account does not show up in the list of accounts on the Budget, and I can't see any way to add it. I'm pretty sure if I credit a payment to the Liability account, I can't also credit it to an expense account. This seems like a fairly common situation. A payment on your loan is an expense that you have to budget for. How do I do this?
I've made a mess. My bank pw changed at the start of the year and I never updated QB with the new one, so I never pulled in any transactions. That's bad enough, but now I'm at the point that my bank won't send them more than about 10-12 weeks worth. This leaves me to have to upload all 9 months of CSV files. I'm worried about invoices paid directly through QB (cc & EFT). They were always in QB of course and I'll be pulling them in as deposits for the 2nd time with my manual upload. Is there any way QB will flag the duplicate deposits for deletion or will I have to do so manually? I also need to delete only the new uploaded version correct? Leaving the QB version alone I would think. This is already a mess and I'd prefer to not make it too much worse. Thanks!
