- Create the first order, go to Edit > Duplicate… and change the name to the new location and save.
- You could also use the batch invoicing feature (Customers > Create Batch Invoice). The items and amounts have to be exactly the same, but it’s quickest way to generate multiple invoices.
I pulled a memorized report that was previously created by someone else called “AP Aging Summary for me” and found that there are thousands of dollars which is listed and shows we owe which are >90. I know for sure we are current on our bills.
I clicked on some of the vendors listed in the “AP Aging Summary for me” report and that they are not open invoices. These expenses were debit charges and the expense was entered by “writing a check”. I also opened another memorized AP aging report for paying bills and it does not show the same info as the “AP Aging Summary for me” report.
How can I correct this?
For more info, search for “financial exchange” in the Help menu.
How to Create a Report for Price, Cost, Gross Margin, and Gross Margin % in QuickBooks Point of Sale
Thank you very much and I look forward to hearing your response.
The names are already exactly matching, they are just tracking separately and show up on the list in different spots. For example, one class shows up in temporarily restricted ->designated donations AND in a general list above temporarily restricted. It’s weird… same exact name tracking separately… this is happening for multiple classes…Thanks.
However, use caution because you need to keep your restricted funds separate from your unrestricted funds. If you’ve got a class in both places, there’s probably a good reason for it. It might be a better idea to rename them instead.
My upstream company requires me to restate transactional data from accrual to cash for use in preparing their report package. I am finding it very difficult to accomplish this at the level of detail I need. So far I have been exporting data to Excel and manually building the “cash” data.
Here’s the example:
I print a “Quick Report” for cash for February. It shows all of the cash receipts and cash payments. I have to drill into each value to find the items (Cost Codes) and customers (Jobs) and spread them manually into an Excel workbook.
I need a report that will match the underlying detail, either by item or by job, with the payment. I think what I am looking for is a report that provides details for actual checks written (choose dates) showing the check number, check payment date, invoice number, invoice date, item (cost code), customer (job), class and amount, either “by job by item” or “by item by job”, where the bill is either PAID (for cash payments in the period) or OPEN (for bills still in A/P).
In my past life I would have simply written a custom report with a report writing tool. Sadly, I’m not sure how to do that in QuickBooks even if I did have the data dictionary and list of tables to query.
Can you help?
- Start with a Custom Transaction Detail report and select Customize Report.
- Select All for Dates, Cash for Reporting Basis, Item Detail for Total By, and add or remove columns to get what you’re looking for.
- Select the Filter tab and select All Income/Expense Accounts for Account and the Customer:Job for Name.
Here’s how you can get a list of unpaid bills by job by item:
Start with a Custom Transaction Detail report and select Customize Report.
Select All for Dates, Item Detail for Total By, and add or remove columns to get what you’re looking for.
Select the Filter tab and select Bills for Transaction Type, Open for Paid Status, and the Customer:Job for Name.
Filtering for paid status only works on bills. Checks and paychecks (as opposed to bill payment checks) will also show up when you select paid status = open so you have to remember to filter for bills only.