Accounting CS adds the account as it is entered in the spreadsheet. If a corresponding account is not listed, select one of the following options. The drop-down list includes all GL accounts that were set up in the Setup > Chart of Accounts screen. In the Accounting CS Number and Description column for each row in the grid, select the corresponding Accounting CS GL account number. The application displays the Data Mapping - Chart of Accounts screen, where you can map the appropriate Accounting CS account to the corresponding account in the spreadsheet. If necessary, correct the data and then click Next. If any issues are found, the invalid items are highlighted. The application validates the spreadsheet data.After you have mapped all applicable columns, click Next. (For example, if you import a balance of $1,200 for a monthly client and select 2015, the application will import a $100 balance in each period for the account.) If you select a specific period end date from the second Column field, the application will import the full budget amount into the selected period only. If you map any budget columns and select the year option (as opposed to a specific period-end date) in the second Column field, the application will equally distribute the amount among all periods within the current year.If needed, you can modify the account number for any new accounts in screen however, you cannot modify the account number for any accounts that already exist in Accounting CS. The application will map any QuickBooks account numbers as is and use the account name/description as the account number for any QuickBooks accounts that do not have an account number. In most cases, even if some or all of the QuickBooks accounts do not have account numbers, you may want to map the account name/description as an account number column.For each column, click the column heading in the grid, and then select the applicable mapping item from the drop-down list in the Column field above the grid.The application will not validate or import data in that row. If the spreadsheet includes column headings or other rows of data that should not be imported, mark the checkbox in the Omit row column for that row.If applicable, select the appropriate template. If you saved mapping information from a prior import as a mapping template, that template will be included in the drop-down list in the Template field.Use this screen to map the spreadsheet columns to specific data fields in Accounting CS. Select the worksheet within the spreadsheet file to import and click Next.In the Import File section, enter the path and filename of the spreadsheet file to import, or click the Browse button to navigate to the file.Select Account Balances from QuickBooks from the drop-down list in the Data type field.In the Source Data screen, select the appropriate client from the Client name field.Selecting the source file in Accounting CS Note that the Show lowest subaccount only checkbox is available only when an account number is assigned to every account in QuickBooks. The checkbox is in the Company Preferences tab of the Edit > Preferences screen when Accounting is selected in the left pane. To import subaccounts correctly and to avoid account duplication in Accounting CS, be sure to mark the Show lowest subaccount only checkbox in QuickBooks. Note: Be sure that the spreadsheet is closed and remains closed during the import process. When the spreadsheet opens in Excel, save the file in a location that you can later access to import into Accounting CS and be sure that it is not password protected.Choose the Create new worksheet option ( new or existing workbook) in the Send Report to Excel dialog, and then click the Export button.Click the Excel button on the toolbar and choose Create New Worksheet.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |