Reports and accounting
Recently active
I need to find the transactions that where done by a certain user for the year 2023. How do I generate an audit trail report "ONLY" for on person on Desktop pro. I know it can be done in QBO but I cant find the filter to just show the person of interest in Desktop Pro. When I run it, it show all users and takes forever and is huge since it lists everyone.
I am building a QB Advanced Reporting report in QB Enterprise in which I want to calculate some transaction-related amounts for tax-reporting purposes. My firm is a manufacturer and distributor that sells many inventory items. I need the report to sum the amounts on all invoice lines during a period that meet two conditions, where each invoice line is a quantity of a product sold multiplied by its unit price in that transaction. The two conditions are custom field values. So, Custom Field 1 value might be either “Y” or “N” and Custom Field 2 value might also be “Y” or “N” and where those custom field values are individually set for each product we sell. The unit price will vary by product and by invoice. In plain English, the calculation might be, for example: Sum all invoice lines (i.e. units sold * unit price for that item in that transaction) invoiced during a specified time period where the Custom Field 1 value for the product in that in
Original commenter did not share additional details
In Report Center under Memorized Reports: is there any way to delete a bunch of reports all at once or do you have to go into each report? Trying to clean up my list and it will be time consuming if I can't select a bunch to delete all at once. Thanks for you help!
I went into our checking account through the Chart of Accounts, see register and half of November is no longer showing. However if I go through transactions, categorized they all show. Is anyone else having this issue or know why it is happening -- I have everything set to ALL.Thanks!
I've noticed some columns like "Created by" or "edited by" in the QuickBooks desktop UI, but I'm struggling to fetch the data for these columns through the API. I've checked the QB desktop docs, but couldn't find any info on getting data for these fields from the API(probably not supported?). Is there any way to find out which QuickBooks user created or modified a Bill or Invoice, and can we grab that data using the API? Thanks in advance!
I need help. I sent a wire to pay our vendor. On the next day, I did the bank feed process to import all the bank transaction to QB. I approved the wire transaction (in bank feeds) but I did not select/or assigned the wire to be applied to specific bills. The wire is now sitting on the vendors account unapplied. How can I apply it?
I buy items with no sales tax because I have a resale certificate. I track inventory of all of my items. Some items I don't sell, I use it myself. I created a customer called "My business" so I can make invoices in order to decrease stock every time I use an item. But now, I have these invoices all open, because I did no pay myself for items I used and I wont pay. This may be easy for most people, but my head is not finding a way to do it. So, my problem is: I need to track what items I have used myself, decreasing stock, but not creating a bill to pay and still tracking use tax that I need to pay for that item. How can I do it?
I just can't understand this system. customers have paid but it's like I am missing how to pull the customer money into the deposit correctly.
Hello, In September 21 2023, I wrote a reimbursement cheque for an employee for some expense she paid for.I closed September but today October 18 2023 she returned the cheque.The cheque has not been checked during September reconciliation.How do I void the cheque without messing up September financial? Thanks
I just tried to go to Reports on Quickbooks online, and the report link was not working at all. Does anyone know why this is happening? I think this might be the first time I've tried to run a report since the menu items changed order - I guess Quickbooks updated things, and this could be one of the reason behind it not working anymore. Thanks in advance.
What in the world is this new email format when sending invoices in QBDT2023. 1. WHY does the FILE Name appear in the invoice template instead of the COMPANY name in the file? 2. WHY does this new format look like a complete scam email? 3. WHY is there a TINY “pay now” button underneath the amount due? With no other prompt that the client can pay online? This is absolutely embarrassing to send and will greatly impact our client’s paying online because they are not going to see the tiny pay now box. I am absolutely livid and want to know when Intuit will be fixing this.
I've never been hard core on fixing my CC accounts within my books, but my new acct wants everything tip top. I have 2 cards under one main cc account. When making payments to the main account, I write a check to cover the online bill payment to the main CC account. But on the balance sheet this comes in as main CC: other and a negative number. What am I doing wrong here?CC main is fully reconciled and looks great, but the numbers don't look pretty once you do a balance sheet.
Hi All, I am new to the Income and Expense report graphic functions, and like how the report features the percentages of income by customer within the month of October. This looks fairly accurate, but do not understand where the total $131,050.11 is pulled from. Is this the total revenue received during the month of October or the amount billed in October? This $ figure does NOT match the total income value in the cash basis P&L for October. The cash basis P&L report Total Income value is $120,032.02 Can anyone explain why the values are different? I want to make sure I understand what this report means. Would the Graph by Customer value of $131,050.11 show up on different reports other than the P&L for October? Thanks so much in advance for your comments and help in understanding this graph!
Hello! Regarding business insurance premium payments which you pay up front, if there was a deductible applied for our company (due to an incident) which later was re-imbursed back to our company from the insurance company, can this be considered 'other income' or should it be logged as a credit entry from Statefarm? (StateFarm is the insurance company we use) Thank you, Janette Maurer
Hello! If your business is receiving a re-imbursement on business insurance deductible, do you apply it as a credit towards the insurance account, or do you apply it as 'other income'? I have read through the questions/situations in QB community regarding 'other income' and health insurance, but none of those quite addressed this scenario. Thank you, Janette
Our company works with a finance company to helps customers pay for our products. Before funding us, they take 12%. Is that something I need to put on the invoice to reduce the amount due so it matches what has been funded to us? I'm unsure how to account for this or how to categorize this.
Can you create an invoice and then select payment, it was available on the old invoice
