RepairQ generates Journal Entries for sales, payments, COGS, inventory, and taxes payable. You can aggregate your entries in a number of ways, giving you the information you need to export from RepairQ and into your accounting system—QuickBooks, Xero, or other software. If you are using our QuickBooks integration, this report can also be used to send on-demand journal entries to QuickBooks Online if you encountered an error during previous uploads.
Additional Resources
- Integrations: QuickBooks Online Resources
- Reports: Accounting System Reporting
- Accounting Journal Entries Overview
- Journal Entries: Set Default Account Classifications
- QuickBooks Integration: Sending Journal Entries on Demand
Viewing Your Journal Entries
1. On the Navigation Bar, go to Reports.
2. On the Reports page, click the Accounting dropdown along the top row of report categories. From the available list, click Journal Entries.
3. When viewing the Journal Entry List, use the available filters to scope results based on the assigned parameters. When you have made your selections, click Apply Filters to run the report.
-
Date Range - Select a date range for your scope of results.
- The wider the date range, the more data has to be queried, which can result in longer wait times for results.
- Location - Select a specific location or run an aggregate report for multiple stores.
- Show Combined Amount (Debit minus Credit) - When unchecked, the report will show individual columns for Debit and Credit journal entries. If selected, this will be combined under the Amount column.
- Show Location - Select to show the Location Column and location details on the report results.
- Show Ticket ID - Select to show the Ticket Column with links to the corresponding ticket for the Journal Entry.
- Show Inventory Item ID - Select to show the Inventory ID Column with links to the corresponding Inventory Item view page for the Journal Entry.
- Show Transaction ID - Select to show the Transaction ID Column with links to the corresponding transaction on a ticket for the Journal Entry.
4. The Journal Entries list will show a summarized breakdown of Account Classifications, Debit and Credit amounts, the date of each entry, and other additional information added at the filter level. You can click the active links to view either the ticket with the corresponding transaction or the Inventory View page for the inventory item.
5. (Optional) To export the report in an Excel-friendly document, click one of the export options on the upper-right of the page. Exports will include any filtered data when running the report.
- To CSV - Exports the report in Comma Separated Values (.csv format).
- To Excel - Exports the report in Excel Worksheet (.xlsx).
Note: You can click Hide/Show Filters to collapse/expand the filters when viewing reports.
6. (Optional) After downloading the report, you can view the spreadsheet with separate columns for Date, Class (location), Account, Debit, and Credit. As long as your chart of accounts matches the accounts you set up in RepairQ, you can then import the file into your preferred accounting software.
START 1.19.X MIG
0 Comments