Reports and accounting
Recently active
The bank transfer was from an operating account to a personal Shareholder account within QuickBooks online (same bank), not an external transfer. The problem with changing the transfer from the Shareholder account to the Shareholder Loan (liability), Quickbooks duplicates the deduction from the operating account balance throwing it off the correct balance.
When exporting a transaction report to Excel, the Excel file does not have all of the columns that were in the original transaction report. What setting am I missing that is making the export exclude most of the columns?
I'm not sure there is an option for this, but I'm attempting to pull some sort of report that will show accurate numbers on payments that include splitting vendor credit amounts. I've tried the Transaction List by Vendor, the Bills and Applied Payments, and customizing a report, but any time I have a vendor credit split between payments and include an "amount" column on a report, it gives me the full credit amount instead of what was actually applied to the payment. I attached a Bills and Applied Payments example that I get when I run that report. The amount numbers are the same in a List by Vendor report. Now, when I pull up the actual ACH payment on QBO I can see the original amount as well as the amount applied, but I have no way to print that.If anyone has found a good workaround so I don't have to go through and manually change these split amounts that would be amazing.
I own a residential remodeling company which is an LLC. I used the LLC to purchase a property to flip with a hard money loan. I didnt handle everything correctly and made some mistakes. So I am trying to record in quickbooks online my Loan, Payments, and Draws. Since it is interest only, I recorded my payments on the loan as "interest expense." Not sure if thats correct. Where and How do I record the Draws? I am a relatively new business owner and I do all the book keeping myself. Probably not the best idea but it has to be this way right now. Also, want to add, I didnt keep expenses separate and it is nearly impossible at this point to track the differences in what materials went where since we remodel by day and flip by night. This obviously requires similar materials. Thanks for any input! JakeTopcraft Construction LLC
We have a client running QB Enterprise, and we review and update his QBE quarterly. Using a QBE backup file, I create adjusting journal entries, and then export to a file using "Send General Journal Entries". Have done this successfully for 5 years.Today the AJE's to clear Bad Debt Expense against Accounts Receivable will not show up in the "Send" window, so I can't save them as a file and import into the client's QBE. The AJE's that do NOT use A/R show up and can be exported.Called Support yesterday, and after an hour on the phone, they did not have a clue, but agreed that it wasn't working right.May also be connected to using Right Networks for the remote desktop, which we started recently.Any help?
Original commenter did not share additional details
The transactions missing are a quickbooks deposit and the corresponding intuit transaction expense. When I asked green dot to audit the statement, the first person told me I was wrong. The second person just simply hung up on me. Quickbooks has verified twice now that what I’m seeing is accurate, but Greendot will not resolve the issue. Since it is a quickbooks branded account, there should be some sort of resolution.
About a year ago I recall being able to press enter or tab out of the account field. Then it changed to where, even if you enter the EXACT account number and the account name shows up, Quickbooks will absolutely not put the account in that field and immediately goes to the add acccount screen. You can't enter and you can't tab. Mainly it's happening with journal entries. It really bogs down data entry. Using spreadsheet sync is equally frustrating because you have to pick an account from a dropdown box and if you have 500 accounts that don't appear on the dropdown list in the order of the number it becomes too time consuming. You can't even paste an account in. I feel like I won't get the answer I want, because I never do when it's a question about how illogical some of these Quickbooks processes are.
I have a problem with my Sales Tax and Tips Liability accounts that I have been searching for answers to for several months, to no avail. I hope someone here can help! There are multiple issues, all related. 1. My restaurant client receives income through both Square and DoorDash. Each month, I do a zero-dollar sales receipt to record the income and fees/adjustments reported by each system. Square reports Sales Tax and Tips collected in their report, but DoorDash does not report either. After much research, I think DoorDash is collecting and remitting sales tax, but this doesn't show up on the statements at all. Since no tax is reported on the statements, my client's tax preparer has been paying monthly sales tax on the total income, including what is reported on the DoorDash monthly statement. Are they actually paying double sales tax on the DoorDash? 2. Because I am only entering the liability for sales tax and tips for what S
I would like to export a report as an Excel file. When I click Excel > Create New Worksheet, the only available option is "Create a comma separated values (.csv) file." The other three options are grayed out. How do I get the other options available to me? Thanks
Hi, I have been trying to customize the report to show the delivery date of the order, unfortunately it's not populating. Does anybody know how? Attached is a screenshot of the report. Thanks!
Unable to edit contractors email address, grayed out. Please advise.
Good Morning!I a trying to run a PURCHASES BY VENDR DETAIL REPORT for a specific date (2016 thru 2021) and vendor. The report will only provide partial information (mid 2020 thru 2021). I have tried to go in smaller time incriments (1 year at a time) but still am not getting any information for 2016 thru mid 2020. I know there is information for the requested vendor. I tried removing the VENDOR filter and still i am not get any information for past years. How can i get this information?
i received an email with a receipt back in the start of January that i had set up the efile and mail to my contractors, im now getting questions where there 1099s are how do i track down whats going on with the 1099s??
QB says to edit "preferences" but I can"t find preferences
I work for a non-profit organization. We have been paying the expenses for another company that we worked with to get started. How should I create the expense account in the chart of accounts to correctly categorize these expenses paid? We are wanting to show it as "Grant" money.
This related to Square Integration and reconciliation. I ran a square report for balances , which shows for example $865.57 was transferred on one specific day. In QB under App Transactions that amount matches perfectly but when I run P&L for that day the square income is something different. What am I missing? If has nothing to do with Square fees it is accounted for in P&L correctly
exact language during invoice bill pay: "No fees apply to the first 40 ACH payments processed during each monthly billing cycle. After that, the fee for each ACH payment is $0.50", and I'm only processing my 3rd this month. Ever since Quickbooks transitioned away from Melio it's done this. I'm paying a monthly fee, but also paying for processing of ACH payments from the first - onward, not after the 40th like it states.
If a customer pays an invoice with cash how do I record it in quickbooks?
QuickBooks Desktop (Enterprise: Manufacturing and Wholesale 22.0) US edition The issue we are facing today is that when we have a Inventory assembly item, we set the markup to be 100%. The Sales Price adjusts to Markup = 100% and Margin = 50%.Then in Edit --> Preferences --> Items & Inventory --> Company Preferences --> Automatic Cost & Price Updates we set:'when item cost changes' = always update sales price'use auto-update BOM cost as assembly cost' check box on.'When BOM cost changes, update sales price.' check box on.Now when we go back to my item with Markup = 100%, if I go down to the bill of materials section and change the cost or quantity of any item in the Bill of Materials the BOM goes up, and the sales price doesn't change. This is the opposite of what we are after, we always want markup = 100% so when the BOM changes the Sales Price should reflect 100% on the new BOM. The last bullet point I mention 'When BOM cost changes, update sales pr
