Reports and accounting
Recently active
How does my client on QB Desktop for PC create a portable file to me on QB Desktop for Mac? I am a CPA that uses a Mac. I need to purchase the right Mac Product to review
Similar to QB Desktop, I want to add a "Markup" column to my estimate template in QBO. I want the ability to manipulate markup on each item from the estimate page. Can that be done?
Good day, I was hoping to run a report that would display what credits are open for Vendors and or Customers. I found an article on QB in the link below. However, this appears to be how much was paid, not what is available. We are running Enterprise 2019 Manufacturing and Wholesale. Any assistance is appreciated. Perhaps I am over thinking this but I am not seeing anything in the stock reports. https://community.intuit.com/questions/1198961-a-report-of-open-credits-for-customers-and-vendors-with-a-total-2014-and-older-versions
A couple weeks ago we moved our books from a server QBD host platform to QBO. There are quite a few mystery vendor credits that keep auto-populating my vendor payment credit fields when I'm paying bills, and I can't find where they're from (I inherited the books from a non-bookkeeper). How do I find a vendor credit in QBO that wasn't entered as a credit? I'm assuming it was an overpayment or a payment made outside of bill-pay, but this particular vendor has hundreds of bills entered over the last 13 years and I'm not sure how to comb through and find the discrepancy.
1) I had the details of the invoice appear in the body of the email. Now it's gone and I can't get it back. 2) I was trying to get the sub customer name to display on the email page. Still can't get this because I screwed up in #1 above.
I have a couple of suggestions I would like to submit as feature requests, but I don't know where the best place would be to submit them.
Hello, in need of some help. I work with a countertop fabrication shop, and when running a P & L report my COGS is currently negative. The main issue I believe is my bills, like mentioned we work with countertops, so we consistently purchase full size slabs of Quartz, Granite etc. and use it for jobs. We don't necessarily use the whole slab for every job therefore I can't put the actual product (i.e. slab) on the customers invoice because it will count for the whole slab and that is not the case for most jobs. I currently categorize vendors bills for slabs under COGS-Supplies and Materials. I also make each new slab/color/material into an inventory item which I believe is where I'm making a mistake. I just need to know how I should be categorizing the slabs, should I be doing 'Material" instead of COGS? Can anyone please give some insight? I know I'm all over the place so please let me know if you need further information.
Currently, we use the US version of QB online which shows how we write date in the US (Month/Date/Year). It is possible to change the dates to show either DD/MM/YYYY or just spelled out like November 25, 2020 or 25 November, 2020? We have operations in parts of Asia and this gets very confusing.
I would like to sort my unbilled time by customer type. I use Desktop Enterprise 2024.
How do I apply a credit memo to an invoice? When I go to Receive payments I get a list of invoices, but just indicating that a credit is to be applied to one of them seems impossible. Do I put the amount in the "Amount" field at the top? Or just next to the invoice? When I check "Apply existing credits" it seems to want to apply all the credits, which I don't want. Why is this so hard? Why can't I just click on the credit and tell QB to apply it to a specific invoice? Please note: I am using the Mac Desktop version.
We purchased recording equipment in 2017 and sold it in 2020.Purchased for $5500 and sold it for $4700 minus shipping expenses.I have the recording equipment as a fixed asset, and I have created a depreciation account but never depreciated it. I do not know how to record the sale and the depreciation.
For instance if a pay a bill net 10, it's a .5% discount
We still have SO many invoices that have been Viewed by our customers that still simply show a status of Sent on the Sales - Invoices screen. It makes things incredibly inefficient when trying to review the entire list of outstanding Accounts Receivable invoices for our customers, and determine which customers might truly not have viewed their invoices yet. You have to click on EVERY invoice individually to see accurately whether they truly haven't viewed it or not.This has been a known issue/bug with QuickBooks since at least January that has been reported and documented and identified as known to the engineers. I re-report it regularly in case they think it has been resolved. Does anyone know when this is going to truly be resolved, or if it is even still on the docket?
I have a service business and all of my COGS is payroll. My pay period ends every second Saturday at 11:59 PM and pay is the next Thursday, via direct deposit on QB Assisted Payroll. I use QB Desktop Enterprise, set to service. It took me many hours every month to do a study and determine my gross profit.I have two issues:The payroll is charged automatically to the pay date. I need it to be charged to the date the work was performed and QB has that information in the timesheet. So I changed the pay date to Saturday; which QB changed to Friday and now my taxes are due a full week earlier. How do I get reporting to recognize the time that work was performed and report the pay date to the IRS?I have the overhead payroll (office workers and sales) on a separate payroll. Their taxes are charged to COGS, which is a significant variance from accuracy in my Gross Profit. How do I split taxes so my Gross Profit (Revenues less COGS) is accurate?
How do I run a profit and loss report by class in Quickbooks Online? I need to run a report for each class as well as a summary report showing each of the classes.
Will QBO export reports to an excel worksheet that has been previously created and saved in a .xlsm (micro enabled) format.
Original commenter did not share additional details
My work often schedules payments in advance, which on the older versions of QuickBooks Desktop was not an issue. However, if we schedule payments to be made and enter those in QuickBooks, those future transactions show on the reconciliation report. Is there a way to disable or limit this? Example: A credit card payment is scheduled to withdraw from bank account X for January 12 and is entered into QuickBooks December 31st, dated for January 12. Reconciliation takes place January third. The withdrawal appears as an uncleared transaction on the reconciliation report, making it seem like the reconciliation date is incorrect because a transaction dated after the reconciliation supposedly took place.
In the new, or "modern," reporting format of Quickbooks online, the setting to round numbers still produces decimals. Before, in the previous reporting format, this same option would remove decimals. I believe this is a bug in the new reporting format of Quickbooks.
I'd like to see a list of most recent transactions in the Transaction Journal in QB Enterprise desktop on Windows 11 Pro. From the top toolbar I clicked on Reports then Transaction Journal and then I get a message window which says "You must first highlight a transaction in a report window or edit a recorded transaction before you can run this reoprt."If I highlight a transaction in the COA and then choose Transaction Journal then it only brings up that transaction in the Transaction Journal. How can I see more than one transaction in the Transaction Journal?
I want to know more reports and accounting in QB Desktop?
I have a situation where I purchased an airline ticket for $173 using a credit card. However, the transaction did not go through, and the amount was refunded back to my credit card. Now in QuickBooks and my bank account, I see two entries:1. A $173.99 expense for the purchase. Initial charge. 2. Later, I received a $173.99 refund labeled as “Credit Card Credit.” It should be "Expense" even it's a refund, right? When reviewing these transactions in QuickBooks, the only option for the refund is to “Categorize.” Once I categorize it, it shows as a“Credit Card Credit.” My understanding is that this should be treated as a refund and still considered part of expenses, but I’m unsure if I need to adjust anything. Could you confirm the correct way to handle and categorize this type of transaction to ensure accurate bookkeeping? I’ve attached screenshots of the transactions for reference.Thank you!
