Overview
The NetSuite Journal Entries report turns a date range of QuikStor ledger activity into journal-entry lines ready to post into NetSuite. It totals each account's activity over the range into a net amount and translates each account into NetSuite's own account number, subsidiary, and class, so an accountant can import it as a journal batch instead of retyping it.
At the Corporate level, one run can cover several facilities, chosen by group or one by one. Managers and accounting staff also use it to check that a facility's NetSuite mapping is in place before the first posting, for both the cash and accrual sides.
Prerequisites
Running this report requires:
The Read NetSuite Journal Entries (Report) corporate-level permission.
Key Terms and Calculation Basics
Before reading the report's columns, learn more about the following phrases:
Journal entry – a record of money activity in the facility's books. Each record has a debit side and a credit side.
Accounting basis – cash and accrual are two standard ways to record money. QuikStor keeps both, and this report includes both.
Net movement – for each account, the report combines its debits and credits for the range into one figure. A bigger debit total shows in the Debit column; a bigger credit total shows in the Credit column as a positive number.
Mapping – the setup that matches each QuikStor account to its NetSuite account number, subsidiary, and class, set up per facility. An account with no match shows its QuikStor name in the Account column and leaves Subsidiary Internal ID and Class ID blank.
Amount format – amounts are shown as plain numbers, with no dollar sign, ready to import. The side that does not apply shows 0.
Report Scope
This article covers the NetSuite Journal Entries report at the Corporate level, which can cover several facilities in one run. A facility-level version of the same report also exists and covers a single facility.
On this report, every entry is dated to the end of the range (see the Date column), so it is not meant for posting entries day by day. For entries kept on their own daily dates, use the NetSuite Journal Entries by Day report.
Report Layout
The report page has a set of parameters and controls above the results table
Report Parameters
These items appear at the top of the report page.
Report name and category: shown as NetSuite Journal Entries, tagged with the green Financial badge.
Facility scope: several facilities at once. The facility groups or facilities you selected appear under the report title.
Date range: the period the report covers, shown as Generated From and To dates.
Report generated timestamp: the exact date and time the report was run, shown as Report Generated.
The NetSuite Journal Entries report header, where Report Generated shows the exact date and time the report was run.
Filter and Export
You choose which facilities and which dates the report covers before you run it, and you can change these choices again from inside the open report.
Selection panel: It has a required From to Date range, pre-filled with the current month, and a choice of whole groups under Facility Groups, single facilities under All Facilities, or a mix.
Export as: downloads the report as CSV, Excel, or PDF. The report has no live connection to NetSuite.
The Generate NetSuite Journal Entries Report panel and the Export as menu offering CSV, Excel, and PDF.
💡 Tip: The Generate NetSuite Journal Entries Report panel also opens from inside the report. Change the date range or the facilities there and run it again to refresh the data, without leaving the report page.
Main Table Content
The results table has eight columns. The first few carry the identifiers NetSuite needs; the rest carry the entry's account, amount, and label.
External ID – the identifier NetSuite uses to recognize the journal batch: the facility code, the subsidiary internal ID, and the date as eight digits (YYYYMMDD), run together with no separators. When the account has no mapped subsidiary, it is just the facility code and the date.
Subsidiary Internal ID – the subsidiary from the account's NetSuite mapping. Blank when the account is not mapped, or the mapping leaves it empty.
Date – the date of the journal entry. On this report, it is always the To date of the range you chose, so every row shows that one date; changing the range changes the amounts, not this date.
Account – the NetSuite account number from the mapping. When the account is not mapped, it shows the QuikStor account name instead, so unmapped accounts stay visible rather than being dropped.
Debit – the row's net movement when its debits are greater than its credits. Otherwise 0.
Credit – the row's net movement when its credits are greater than its debits, shown as a positive number. Otherwise 0.
Memo – the QuikStor account name for the row (the grouped name when a grouping applies).
Class ID – the class from the account's NetSuite mapping. Blank when the account is not mapped, or no class is set.
The NetSuite Journal Entries report table with the External ID, Subsidiary Internal ID, Date, Account, Debit, Credit, Memo, and Class ID columns.
ℹ️ Info: When a facility's accounts are not yet mapped to NetSuite, the Account column shows the QuikStor account name instead of a NetSuite number, and Subsidiary Internal ID and Class ID are blank.
ℹ️ Info: If no transactions match the facilities and date range you selected, the report does not show the results table. Instead, it shows No Results Found with a note to adjust your search. Widen the date range or change the facility selection, then run the report again.
Sorting
The report opens sorted by the External ID column. You can sort by any column to reorder the rows, and the × at the end of the results header clears the sort. This report does not include a total row.
FAQ
These are the most commonly asked questions about the NetSuite Journal Entries report.
Why do I see No Permissions when I open this report?
Your role does not have the Read NetSuite Journal Entries permission at the Corporate level. Ask an administrator to turn it on for your role, then open the report again.
Why are some columns, like Subsidiary Internal ID or Class ID, empty?
These columns are filled from the mapping that links QuikStor's accounts to NetSuite. When an account is not mapped, its Subsidiary Internal ID and Class ID are blank, and the Account column shows the QuikStor account name instead of a NetSuite number.
Why does the Account column show a name instead of a number?
The account is not mapped to a NetSuite account number, so the report shows its QuikStor account name instead. An account can also show its name when it is mapped for only one basis (cash or accrual) and not the other, since the mapping is set up for each basis on its own. This keeps unmapped accounts visible so you can finish the mapping before posting.
Why do the amounts have no dollar sign?
Amounts appear as plain numbers so they are ready for import into NetSuite. A side that does not apply to a row shows 0.



