-
How to filter the Account of Parent Subsidiary?
Hi Guys, Now I need to create a saved search for Trial Balance Revenue. Here is my saved search Here is the running result: The account in the result are a parent subsidiary. My question: How to filer the Account of Parent Subsidiary? Does anyone know how to deal with this? Many Thanks Jet
-
Retained Earnings Year End Trial Balance
Hello Community, As I was checking the retained earnings balance each year end, I've found that the Trial balance is not retrieving the expected number for the retained earnings as I've calculated it. I know that the Retained earnings has 2 sectors that calculate it: Cumulative Balance of the Transactions directly posted…
-
Trial Balance as-of period mismatch
Dear All, We have a customized trial balance, showing balances as-of months and running according to the given report date. We realized that balance for May 2026 is actually the ending balance of April 2026. Previously, report was showing the balance as of period end. Not sure if someone changed a setting, now it is not…
-
Saved Search COGS & Invoice Amount Not Matching with Trial Balance ?
I need a Saved Search that includes the following details: Sales Order Document Number Related Item Fulfillment COGS Amount Invoice Amount The total COGS Amount and Invoice Amount should match the Trial Balance report. However, when I tried creating the Saved Search, the totals are not matching with the Trial Balance…
-
Custom Trial Balance Report - Opening Balances and YTD Activity
Hi. We need to export a customized trial balance that follows a prescribed format. Opening Balance as of Current Year | Postings in Current Period | Postings YTD | Current Balance. Assume standard calendar year For Opening Balance as of Current Year: We're using Trial Balance: Amount > Last Fiscal Period for the Opening…
-
WATCH: How to add an Opening and Closing Balance Column in a Trial Balance Report
This video will show you how you can customize your Trial Balance report to show the Opening and Closing balance and the total Debits and Credits for the reporting period.
-
Trial Balance Remove grouping and parent
Hi Team, I am customizing a Trial balance report. I removed the grouping, I also removed the original fields. I added the Account number and name separately as columns. We also removed the sorting by account type. What we noticed was that the accounts are showing in twos.
-
Trial Balance
I want to to know is their a way to make a Trial Balance/Balance Sheet model to be this way ? (Picture joined in report with six debit/credit columns) ((or is it not even the trial balance but Balance Sheet because I think I have two issues the translation for balance géneral from french to english in my netsuite seems to…
-
Migrate Historical Intercompany Trial Balance
Hi Team, We are in the process of migrating our data from Quickbooks to NetSuite however we are encountering issues with migrating our Intercompany balances. We encountered error message: Elimination settings for the journal line, account, and name do not match. To check this line for intercompany elimination, you must…
-
In "Trial Balance with Foreign Currency", column "Amount (Foreign Currency)" displays strange values
The Amount (Foreign Currency) column in the "TB - Trial Balance with Foreign Currency" report displays unusual numbers. See attached image. The subsidiary's currency is GBP. For account 5806, debit is 9,596.75 GBP, but 0.00 USD under Amount (Foreign Currency). For account 5820, credit is 4,864.97 GBP, but -8.96 USD under…