Reports and accounting
Recently active
I am posting this in the hopes that anyone who follows me down this rathole will find it and not spend hours banging their heads against their desks in frustration.If you are using Advanced Reporting for Quickbooks, which is derived from Qlik, you may discover that a critical constant value inside Quickbooks has a typo.One of the constants for the Transactions.Classified Account Type field is "Assest", not "Assets"; attempts to extract the desired data from the database will fail unless you have used the correct (typo) constant.ResolutionWhen accessing this field, use the constant value "Assest" not "Assets".CauseTo the best of my ability to determine this is an error inside the QB system and is not actually a Qlix defect. Related ContentI discovered this while using the Advanced Reporting tool in Quickbooks Desktop Enterprise, while modifying one of the default reports provided. Specifically, while working on a report to extract sales data, I found this boilerplate code:sum(if(No
There is a "closing entry" in retained earnings but no closing date as ever been set up in preferences.How do I reverse closing entry if there is no closing date in preferences to take off to reverse this entry.
I've attempted multiple times and have even used my personal and work email and still nothing.
Dear QB, I am Phiroun and I am the user of QB for more than 10 years for my job career, so today i want to request to add more function of class to track Receive Payments cause i have multi-company in one QB company file but when i check Balance Sheet by class the cash in bank or cash on hand is wrong amount because of no class to track cash in by Receive Payments, thanks please help to consider to more this function, thanks.
Original commenter did not share additional details
I am using QBO.My client has 3 PayPal foreign bank accounts listed in the Chart of Accounts (PP AUD, PP EUR, PP GBP). The Quickbooks balance on the chart of accounts screen shows 0.00 for each account. The Balance Sheet shows small amounts for each account. The transactions in those balances stem from 2017. I need to zero out all 3 accounts but am unsure as to how to do it. Thanks for your help!
How do I receive inventory/create a bill for my purchase order when I get the inventory delivered?
I've discovered a few of these, but here is one example. This is a report of a COGS account. The amount of $812.73 is the average cost that I see when I open this Item to edit it. The actual cost of the item cost on this transaction was $759.36 so another entry was created by QB for $53.37 which is the difference. Why is QB doing this on this item? I have many other items in this same COGS report whose cost differs from the average, but no such entry was created. I've compared items and can't see why this one item is being treated this way.
I have done many journal entries, how do I run a report to see them?
Hello, HELP!!! We are a racing car company. We buy materials and parts from vendors but we do not resell them. Our team uses them to rebuild the cars for the next race. So for bookkeeping purposes I'm lost.We want to keep up with inventory properly but I'm not sure how to go about it. I think i only need to enter a cost value?Thanks,Janet
Hello, Situation: my company recently took over our payroll from another company. The other company was not invoicing us for the payroll expenditures for many months. This resulted in a large sum of money being owed to the company at the end of 2023 however the bill for the outstanding amounts were not provided to us until 2024. The bill transaction was entered into our system when we received it in 2024 for the 2023 payroll amounts owing. The cheque was issued in July of 2024. Our auditor had provided us with the adjusting journal entry to capture the expenses in the correct year. However, when running our budget vs actual report the amounts for last years salary still appear in the report after to journal entry to correct the amount. How do I correct this as it is showing our budget as being over?
Hello, Can anyone tell me how I can pull these charts out of the performance center? They are great charts and we could use them , but not everyone can sign on and see these I need to print or PDF these to others? Please let me know if anyone knows how to do this properly Thank youRM
If I link the PO to an expense or bill, it closes the PO and assigns the items to my inventory immediately...which does not work for me.
I am thinking of switching to Quickbooks Online. I do a large volume of invoice billing through Accounts Receivable. Due to a quirky set up in the company profit and loss statement, I would need to post some of the line items on the AR invoice to a cost of goods general ledger code rather than an income general ledger code. Will the AR let me do this, split my invoice credit side entries between income and some cogs accounts?
I know accounting but I'm new to quickbooks. I'm sure the info is in manuals but I don't have time to learn new systems every day. (My philosophy of UX is that) things need to be made intuitive. So my question is: I linked bank accounts to my QB bookkeeping account and I'm classifying the transactions. That's nice. I like the linking feature. This one specific question will probably address multiple questions I have about the platform. I paid $201 with my management company (this qb account) to a landscaper on behalf of a different LLC client entity (in a different qb account). I then reimbursed this management corp from that LLC via my bank website- so both of these transactions show up in the set of quickbooks transactions to be categorized. While I don't know exactly what the payment on behalf of the LLC should be technically (GAAP) classified as, I know they are an asset/receivable so I put them down for now as uncategorized assets, similar to how I put paid to this
When exporting detailed reports, they are formatting extremely strange. Always portrait style, and data is spread out across multiple pages. So a 10 page report is 40 pages when I export. I know I can export to a Spreadsheet, but I'd like it to export simply as it looks on my screen. Is this a known issue?
