How can I properly get monthly totals into Quickbooks Desktop Pro 2020 as I am merging our company records into one complete file? Prior to my employ the Payroll and the Accounting were two separate "companies". I need to have monthly data for the prior year to be able to run reports but we do not need specific data (ie: only the total for Accounting expense, not the individual checks cut to pay such expense).
I'll share some insights on how you can get the monthly historical balances as you merge the company records into one complete file.
You can load the general ledger balances for prior periods en mass. Make sure to check the date for it will matter for the detail of your report. When you plan to open a monthly reporting, then you can fasten it to monthly. If quarterly, then you can set it to quarterly.
You can go to the File menu and then select Utilities. Choose Import and then pick General Journal Entries.
Also, you may need to have a reference if you're going to import general ledger balances from a different program, you can check this article: IIF Overview: import kit, sample files, and headers. The general ledger balances must have to be an IIF (Intuit Interchange Format) file to save it in QuickBooks.