Reports and accounting
Recently active
I am trying to get my mileage deduction to reflect in my profit and loss statement. I have entered all the miles by uploading it from Mile IQ and I can see the miles in QB categorized as "Business". I have also registered my car and estimated my miles. But none of it transfers to my P&L and or my schedule C. I know this must something simple missing ... please advise as I have tried everything.Thanks
Hi there all you nonprofit QBO Plus users.... I am new to QB and have a question about the Chart of Accounts. I understood that when you set the organization to nonprofit and the tax form to 990, that the Chart of Accounts would change to use terms like Income instead of Revenue for the Type. Mine hasn't. Suggestions? Thanks.
I have quickbooks desktop 2021.I want to generate a report that has customers that are 30-60 and 60-90, but I do not want on the report 1-30 and current. How can I do that? Thank you
Original commenter did not share additional details
Okay - I know there have been plenty of questions and posts on this. I understand a JE is really the only way to get these other balances back to zero. However - I can't figure out what the journal entry should be and what should be entered each month when reconciling. Here is a screen grab. The parent account matches what the bank balance says. But the two sub accounts are way off. Any insight/help is appreciated.
I would like to print a report that essentially looks like the Chart of Accounts (Account Listing) with the normal options for that, for the Income & Other Income, and then another for the Expense and Other Expense accounts for the year, but in the "Balance" column I would like it to print the total of the income or the total of the expense for the year. I know I could print the trial balance for the dollar totals, but I'd like some of the info from the GL Account detail. Does such a report exist or can one easily (key word) be created? Thanks in advance.
Hello, I wanted to know if there is a way to create a Trial Balance Report in QuickBooks Desktop that shows columns by month instead of one column with an ending balance. For the P&L report, we can click on 'Display Columns' and choose 'by month,' but I cannot find that option for the Trial Balance. Is there a workaround to run a Trial Balance by month?
My nonprofit ministry just received a donation from a family fund that came to us via Morgan Stanley Giving Fund (MS GIFT). Essentially the donor gave MS GIFT money which they passed along to us. How is this recorded? It seems right to attribute it to the actual donor but how do I record MS GIFT involvement if at all?Thanks
I have printed a Transaction Detail by Account in the Sample Company accessed in QBA. I did this to trace a few entries all the way through the QBA system, since I am a new user who loves getting down in the details. Anyway, when I printed the report out, sorted by transaction type, I noticed that in the column "Full Name" that almost all entries had the corresponding offset account listed. However, there were a few that did not, and that's what is bothering me. Both invoice #1001 and 1016 should have the "Full Name" as "Landscaping Services". However, invoice #1001 has that field blank, while invoice #1016 does show "Landscaping Services". Both invoices seem to have the same fields shown on the individual invoices, but I must have missed something. Does anyone know where the "Full Name" column on the Transaction Detail by Accounts pull its information from? I am not sure this is even the correct source, that's what I'm trying to figure out.
Restructuring the GL to create order, and wondering: * Is there any way to change the GL Type when an existing account was identified as the wrong type when set up? I know I can create a new GL and transfer the balance via GJE, but if possible I would like to change the type followed by changing the GL # to also transfer the history with the account. I have a number of accounts in this situation ... I believe the people in accounting in years past meant well but didn't really understand the implications of the GL Type nor the customary numbering scheme used in accounting. Thanks in advance for your time and assistance in sharing knowledge.
Has anyone else experienced this bizarre issue? While batch modifying locations (not classes) in QuickBooks Online using the Reclassification Tool, the customer or vendor name on an invoice or bill randomly changes to another customer or vendor’s name!This has now happened to me twice in the past few days—once with a customer invoice and once with a vendor bill. At first, I thought I must have made a mistake, but after the second instance, I know for sure this is happening solely when I modify the location field.Here’s how you can reproduce it yourself:Open the Reclassification Tool in QuickBooks Online.Choose any bill or invoice that currently does not have a location assigned.Reassign the location to any value (e.g., Location X).Watch as the open bill or invoice moves from the existing customer or vendor to a completely random customer or vendor!This is beyond frustrating! I spent over 1.5 hours on a call with Intuit support, sharing my screen and going through extensive troubleshoot
My client wants me to create a 'project cost estimate' via the API. However, it seems that using the API I can only create an estimate, but not a 'project cost estimate.' These appear to be completely different structures that are not comparable at all. A 'normal' estimate has fields:'Amount', 'Description', 'Quantity', 'Unit Price', 'Item', 'Service Date', 'Tax Code', 'Class' A project cost estimate has fields: Service Date, Product/Service, Description, Qty 'Your Rate Hidden, 'Your Total (Hidden)' , Markup% (Hidden), Customer Rate, Customer Total Tax [], Billable []Is there any way to create a project cost estimate via the API with the actual fields and structure of an actual project cost estimate? Creating a standard estimate and calling it a 'project cost estimate' is not the goal, but I would be happy with any possible solution to this issue even if it's complex. As an aside, why are all of the project facing features restricted on the API?
I spent days trying to bulk edit existing products in QuickBooks Online, then the Customer Support confirmed that it is not an existing feature. All I can do is update the thousands of items' sales and purchase prices one by one. The import csv/xls function doesn't work, as it keeps giving me the error message that these items already exist. It's such an essential feature. These data keep changing all the time. How can users deal with this issue? Profit and Loss reports will give a false result if these data can not be updated. Am I missing something?
Hi,my balance sheet is still showing some old accounts how do I remove them?Thanks,Noel
I am new to the QB system and I am trying to understand how the QB internal defaults work. For example, is there a table that I can see where all the transaction default accounts are setup? Can any of the routing be changed by the client or QBA? For instance, I can tell by reviewing the Transaction Detail by Account, which I sorted by Transaction Type, that all Bill Payment (Check) transactions are credits to Checking and debits to Accounts Payable in the Sample Company. Is there a place I have access to that shows where this routing is located? Perhaps in QuickBooks Advanced? I'm trying to gain an understanding of what customization, if any, is available. Thanks for your help!
I have made some Quantity on Hand adjustments for year-end inventory and now would like to print off a report or summary showing the item and its variance, with total dollar adjusted amount. Is this possible within QB Manf & Wholesale 24.0? Thanks!
I would like to help my dad setup a QBO for his woodworking business that he owns and operates independently. He has never used a bookkeeping software or service. He also does not have a history of cleanly maintaining an online record of business transactions and financial statements. I am considering to purchase live expert help to construct historical financials for his business and to establish a baseline for bookkeeping moving forward. Is this something a QuickBooks advisor can help with? What is the minimum documentation (e.g., tax returns, bank statements) that QuickBooks advisors need to provide this requested support? Do advisors have experience working with business owners who do not have a history of maintaining online bookkeeping records?
How can I create a report that shows sales that includes by Job Type? I know how to filter by Job Type, but I don't want to filter I want to report the Job Type so that it shows as a column heading. For example, if I have residential, commercial, and retail job types I would like to report what last year's annual sales was for each job type. Thanks!
I want a listing of all the classes. How do I print? In Reports / Lists there is no option for Class List.Under the tab Class in the Class entry, the display says to use Reports / Lists.Another QB endless loop.
When I try to respond to a prior message from Big Red Consulting, I get Authentication Failed.... something about a Mismatch???? Why?
Hello, I have never reconciled prior years of using QuickBooks and this is throwing off my current "in QuickBooks balance". I have reconciled 2024 and need help to clear out old years from my current numbers.
I often require a % down to start a job. How do I send my client an invoice that has two payment options? one for final payment and one for the initial deposit
I am changing the account to be used as the Undeposited Funds account for receipts, and I thought I saw a place in Preferences where the account number to be used was entered ... but I've looked through all and can't seem to find it. Can someone please slap me upside my head and let me know where I need to update this info? Thanks .....
I have an accounting background but am newer to QuickBooks. I didn't set up our organizations existing chart of accounts and financial statements. For the new year, I'd like to start fresh - set up a new chart of accounts and reformat/set up new financial statements. I'd like to do this but still have access to, leave intact the existing and prior year financial statements and chart of accounts. Any assistance is appreciated.
