Thanks for sharing detailed information about your concern, @lrhmail451.
Let me help share some steps on how your bills and payment will show up in your Profit and Loss report.
The difference between cash basis and accrual basis reporting is how the date is determined for reporting the income or expense. Please note that the cash basis report will use the bill date.
In your case, since it shows Bill Payment (Write Check Against AP), you'll need to edit your IIF file. Then enter the correct information in the file.
Here's how:
- In Microsoft Excel, go to File and select Open.
- In the File type dropdown, select All Files.
- Select the IIF file you want to edit, then select Open.
- In the Text Import Wizard, select Next, then Next, and Finish.
- Make the changes to your IIF file.
- Go to the File menu, select Save, then Yes.
- Exit Excel. You'll get a prompt to save the IIF again. Select Don't Save.
Once done, you can import the file again. Before doing so, make sure to create a backup to restore your data in case you run into problems. For complete details see this article: Export, import, and edit IIF files.
Also, to fix the template you use, we can run the Verify and Rebuild Data utility. The tool scans data issues within the file and self-resolves them.
I've also included an article that'll help you check the complete list of workflows and other vendor-related transactions: Accounts Payable workflows in QuickBooks Desktop.
Keep me posted if you have any other concerns or follow-up questions. The Community always has your back.
