Reports and accounting
Recently active
Hi, I've got 3 employees and have just started offering 401Ks through QBs payroll and their partner, Guideline. We are not yet matching contributions. The first deductions were made from paychecks in the last payroll run. All good. I've just downloaded a bank transaction representing a payment of the employee 401K contributions to Guideline. I'm confused as to how to categorize it in QBs? Is it assigned to one of the payroll liability accounts? Appreciate any help here...THXP
Original commenter did not share additional details
We've bought some product in bulk using 2-sided non-inventory items, to COGS. But it seems neither the Job Profitability or P&L reports will surface the cost of those items when reporting customer sales for a particular period. Is there a report that will? Or, is there something we can do at time of invoicing so that those costs will appear in one of these reports?
Unable to set up an invoice in the app
Since the vehicle is already on the balance sheet as a fixed asset, should i depreciate its value? If so, according to what timeline? 60 months?
Good day, We're working on our custom invoice layout.We would like to have an additional column, not automatically populated, for each item in the invoice, i.e. adding the custom column to the activity table.This is because we would actually like to fill that by hand, so we just need the column header and the space to write. It seems that custom fields are for other areas of the invoice, but not for the table with the products. Is there a workaround for this? Thanks
Here is my assumption of the meaning of what I've read about using Classes for expense and income. Please let me know if I am correct or if I've misunderstood something. If I misunderstood, please explain to correct my understanding. Example: If we have a master account and sub-accounts that roll-up into the master (example) 6100-00 Advertising 6100-01 Print Advertising 6100-02 Radio Advertising 6100-03 TV AdvertisingAND if we have "Classes" to identify various events that we hold throughout the year, (example) MGR - Madri Gras STP - St. Patricks Day 4th - Fourth of July Each "event" will have multiple advertising expenses, each of the categories listed above. I assume that we could identify invoices for Radio Advertising sometimes with MGR, some with STP, and some with 4th. So we could report on the total Radio expense for each event (class) OR we could report on the total Radio Advertising expense by not asking for a "class" report.
At my firm we often receive bills in foreign currencies from vendors. When we go to pay the bills in QuickBooks the exchange rate has frequently changed from what it was when we received the bill. So we pay the bill and now it either looks like we haven't paid the bill in full or it looks like we've overpaid. This is further complicated by the fact that we include 'billable' bills on the invoice to our clients. Our process looks like this: We receive the bill and then invoice our clients first for the amount of the bill and then after the client pays us we pay the vendor. In that time the exchange rate has changed several times and the amount we are paying is no longer the same as the amount of the bill on the invoice. I'm considering changing the amount of the bill to reflect the rate on the date we pay it???If you can make sense of this somewhat jumbled question I'd really appreciate any advice on resolving this issue.
For example, the invoice total is $500.00 which consists of 5 line items at a rate of $100 each. Should each line item be entered on the invoice in QB?
I currently have it set up: - Create: 30 days in advance - Interval: Monthly on 1st of every month - Terms: First Day of Month It then sends the invoice with the invoice date and the due date the same, being the first of the month. But I need the invoice date to be the day it is sent. I've also tried "Net 30" in the Terms, but then it sends 30 days prior with the invoice date being the date I want it to be due, and the due date 30 days after that. Is there a way to make sure the due date is the first, it's sent out 30 days prior, and the "invoice date" is that date that it is sent out?
I am trying to get my transaction report to also display the payment method. In the New Reports experience, I have selected the "Payment Method" column to display as visible, but every row is blank. I have checked a sample of the transactions listed in the report and all had the payment method data filled in. My report is not displaying them for some reason.
I made a vendor a customer by mistake when I first entered them. How can I change them to a vendor? thank you.
Seriously does anyone have a workaround for the ommission of price rules in the update? I just don't understand how they think taking features away is solving anything.
When doing year end closing of an owners draw account for a sole proprietorship, should the other side of the entry go into owner equity, or owner capital? Looking at other sites, they almost use them interchangeably, but I know they are not the same. The COA for this company currently only has an owners equity, so I am guessing to use it. Just wondering if someone could clarify a bit for me. Thanks!
When I print out a Open Sales Order Report it shows correctly. But When I make the report for Detailed Open Sales Orders it gives me Negative Numbers for Quantity and Amounts Any ideas what I am doing wrong? I get the Details by: Reports - Sales - Open Sales By CustomerThen: Customize Report: Filters Detail Level = All or all but summary. Actually Quickbooks Premier Plus Mfg and Wholesale edition
Good morning! I'm hoping you can help me with an inventory issue. When we first set up QBO, we were not intending to use it as our primary accounting system. Thus, when I set up products, I put in nonsense inventory numbers. Fast forward to a year later, when our company has determined this will be our primary accounting system :) The current inventory numbers for all products in QBO are incorrect. I now have our exact 5/31 inventory numbers in excel and can do an inventory quantity adjustment in QBO. But, when I do, it creates a huge inventory shrinkage. Is there a method to either eliminate that inventory shrinkage, or somehow do this inventory adjustment without creating the inventory shrinkage? We don't really need the historical stuff to be correct, just want it to be correct going forward and not reflect that huge inventory shrinkage. Even if there's a work around or anything like that, it would be fantastic. Thanks in advance for any help you can provide!
Using QB Desktop Pro 2020. I'd like to create a report of all expenses for a given period, not just vendors. Internet searches show this for QB Online, but I'm having trouble doing it in my desktop version. I'd like the report to not just summarize, but rather to show each of these expenses in detail.
I know I can add the info manually, but am trying to avoid that step. Just have them add the information themselves since they are already a contractor in my account.
Hello! I have a nonprofit and I get donations through Zelle into my bank account. I used to have Quickbooks Desktop but recently switched to Quickbooks Online. Is there a way to mass categorize these individual transactions?
Hello, I'm working on journal entries for an investment account, but am at a loss for the month that all of the investments were sold. One of my clients invested funds in Treasury Money Market accounts, an ETF (stock), and Treasury Notes. The brokerage statement lists unrealized gains and losses for the ETF and Treasury Notes. All of these investments were sold this year, all with gains, but the brokerage statement has $0.00 capital gains and losses on the statement. What am I missing? Dividends were earned on the Treasury Money Market accounts, so it doesn't seem that these accounts will have a Realized gain or loss when sold. When each of the Treasury Notes were sold/redeemed, interest was added, so perhaps these don't have a Realized gain or loss either, even though the statement tracked Unrealized gains and losses. The ETF sold for more than the cost basis, so there should be a realized gain (less than $100). Why isn't this on the statement?&nbs
