We might need reports from the customer’s legacy system, to get the transaction details for data migration into NetSuite. Here are some ways to fetch transaction details, if the client is using QuickBooks.
First, the QuickBooks account must be logged into, and then the “Reports” section should be accessed. By searching for “Journal” in this section, the general ledger report, which contains all transactions done in the account, can be found. To refine the report by date, a date range must be selected, such as “from” and “to” dates or options like “last month” or “last year”. After selecting the desired date range, the next step is to customize the report by choosing the necessary columns. Once customized, the report can be exported to Excel by clicking on the export sign located at the top right corner. This export will provide the transactions line by line, including any necessary details.
However, it’s important to note that certain details, such as currency, will not be available in the Journal report. To retrieve this information, the “Transaction List By Date” report must be obtained. In this report, the date range should be selected, and all required fields should be added after customizing it. Additionally, it is crucial to use the exchange rate from the “Transaction List By Date” report because the exchange rate in the “Journal” report is rounded off to two decimal points.
In summary, by following these steps and retrieving the necessary reports from QuickBooks, the migration process can be simplified.