Overview
The NetSuite Journal Entries report turns a date range of one facility's 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.
The report covers one facility opened in the Facility Switcher. Managers use it to check that the 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 facility-level permission.
Key Terms and Calculation Basics
Knowing more about the following terms helps before reading the report:
Journal entry – a record of money activity in the facility's books. Each record has a debit side and a credit side.
Accounting basis – QuikStor records money in two standard ways, cash and accrual. This report covers both.
Net Movement – for each account, the report adds up its debits and its credits for the range and shows the difference as one number. A bigger debit total goes in the Debit column; a bigger credit total goes 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 for each facility on its own. If an account has no match yet, the Account column shows its QuikStor name instead, and the other two stay 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 Facility level, which always covers one chosen facility. However, the corporate version of the report can cover several facilities in one run. Therefore, if you need more than one facility at once, use the corporate-level NetSuite Journal Entries report instead.
⚠️ Warning: Every entry on this report is dated to the To date of the range, not to the day it happened. The range is pre-filled with the current month, from the first day to today, so a mid-month run dates the whole partial month to that To date. If the To date is changed, every row carries that date instead. Posting this batch places all of it in that one period.
💡 Tip: You cannot choose the facility from inside this report. It always uses the facility selected in the facility switcher at the top of the page. If you manage more than one facility, switch to the one you want there before you run the report.
Report Layout
The report page has a set of parameters and controls at the top of the screen and the result table below it.
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: a single facility – the one selected in the Facility Switcher at the top of the page.
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 report header shows the report name and Financial category badge, the single facility, the Generated From and To date range, and the Report Generated date and time.
Filter and Export
The report covers a date range that can be set before the run and changed again from inside the open report.
Date range: the date range is required but comes pre-filled. When it is left unchanged, the report uses the current month, from the first day to the day of the run. Inside the open report, the panel re-opens to accept a new date range only; the facility cannot be changed there.
Export as: downloads the report as CSV, Excel, or PDF.
The Generate Report - NetSuite Journal Entries panel and the Export as menu listing CSV, Excel, and PDF.
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 – an identifier built from the facility code, the account's subsidiary, and the current date. Because it includes the subsidiary, rows that use different subsidiaries can carry different External IDs within the same export. When an account has no mapped subsidiary, the External ID 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 results table with its eight columns: External ID, Subsidiary Internal ID, Date, Account, Debit, Credit, Memo, and Class ID.
ℹ️ Info: When the 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 there are no transactions for the facility in the date range you chose, 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, then run the report again.
Sorting and Totals
The report opens in its default order. It does not include total column rows.
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 Facility level. Ask an administrator to turn it on for your role, then open the report again.
How do I export the report?
Use Export as in the top-right corner of the open report. You can export as CSV, Excel, or PDF.
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 the mapping can be finished before posting. When an account is unmapped, its Subsidiary Internal ID and Class ID are also blank.
Why is an account with activity missing from the report?
A row shows an account's net movement for the range - its debits against its credits. An account shows up when its activity nets to an amount for the range; the rows that appear also depend on how accounts are mapped and grouped.
Which facility does this report cover, and can I change it here?
The report covers the facility selected in the Facility Switcher at the top of the QuikStor page. You cannot change the facility from inside the report. To review a different facility, switch to it in the Facility Switcher, then run the report again.
What date range does the report use if I do not choose one?
The date range is required, but it is pre-filled. If you do not change it, the report uses the current month, from the first day to the date you run the report. You can pick any other range before you run it.
Why does the report show No Results Found?
There were no transactions for the facility in the date range you chose. Pick a wider date range and run the report again.



