The Accounting Dataset has 5 sheets within the single spreadsheet. Its used to collect accounting data for chart of accounts, credit terms, sales tax.
| Chart of Accounts | ||||
| Column Name | Required | Value Type | Description | Example Value |
| Account Number | Yes | Number | The unique identifier for the account | 11100 |
| Account Description | Yes | Text | The name of the account | Checking & Savings |
| Account Type | Yes | Text | How the account is categorized. These account types are predefined and cannot be changed for your workspace. Available values: Asset, Expense, Liability, Equity, Revenue. | Asset |
| Account Subtype | No | Text | Another level of account categorization. These types are created by you and will affect how financial statements add up subtotals for each Account Type. | Current Assets |
| Account Second Subtype | No | Text | A tertiary level of account categorization. These types are created by you and will affect how financial statements add up subtotals for each Account Type | Cash Accounts |
| GL Mapping | ||||
| This sheet maps your company’s Chart of Accounts to the GL Accounts required by your workspace. These required GL Accounts are used to run automated processes, which makes accurate mapping of your custom Chart of Accounts essential. | ||||
| Column Name | Required | Value Type | Description | Example Value |
| Required GL Accounts | Yes | Do not make changes to this column. These are the required GL Accounts your workspace uses. | ||
| GL Account Number | Yes | Number | The unique identifier found in the previous "Chart of Accounts" sheet, that correlates to the required GL Account. | 11400 |
| GL Account Name | Yes | Do not make changes to this column. Values in this column will update when you change the "GL Account Number" to the Account Number for your company's correlating Chart of Accounts. | ||
| Customer Credit Terms | ||||
| Column Name | Required | Value Type | Description | Example Value |
| Credit Routine | Yes | Number | The identifying number for the credit routine. The Credit Routine will be used in your Customers Dataset to assign credit terms to your customer. | 1 |
| Description | Yes | Text | A clear name for the Credit Routine. | Net 30 |
| Past Due Days | Yes | Number | The number of days after an invoice due date before it is considered past due. | 30 |
| Sales Tax Routines | ||||
| Complete this sheet if your company will use Avalara for tax calculations (ignore the "AturianTaxRoutines" sheet) | ||||
| Column Name | Required | Value Type | Description | Example Value |
| Tax Routine | Yes | Number | The unique identifer for this routine. | 1000 |
| Description | Yes | Text | A clear name for the tax routine | Tax Exempt |
| State Percentage | Yes | Number | The state's tax percentage | 6.25 |
| County Percentage | No | Number | The county's tax percentage | 1.75 |
| City Percentage | No | Number | The city's tax percentage | 1.25 |
| Other Percentage #1 | No | Number | Other tax percentage to be added | 0.75 |
| Other Percentage #2 | No | Number | Other tax percentage to be added | 0.50 |
| Other Percentage #3 | No | Number | Other tax percentage to be added | 0.25 |
| State G/L Account | Yes | Number | The account number for the correlating chart of accounts. Found in Chart of Accounts sheet | 21870 |
| County G/L Account | No | Number | The account number for the correlating chart of accounts. Found in Chart of Accounts sheet | 21870-1 |
| City G/L Account | No | Number | The account number for the correlating chart of accounts. Found in Chart of Accounts sheet | 21870-2 |
| Other G/L Account #1 | No | Number | The account number for the correlating chart of accounts. Found in Chart of Accounts sheet | 21871 |
| Other G/L Account #2 | No | Number | The account number for the correlating chart of accounts. Found in Chart of Accounts sheet | 21872 |
| Other G/L Account #3 | No | Number | The account number for the correlating chart of accounts. Found in Chart of Accounts sheet | 21873 |
| Tax Freight? | Yes | Yes/No | Should tax calculations include freight charges? | Yes |
| AturianTaxRoutines | ||||
| Use this sheet if your company will use Aturian for tax calculations (ignore the "Sales Tax Routines" sheet) | ||||
| Column Name | Required | Value Type | Description | Example Value |
| Tax Routine Name | Yes | Text | A clear name for the tax routine | Illinois Sales Tax |
| State | Yes | Text | The state the tax rate applies to | IL |
| Customer # | No | Number | The customer's number identifier | 1000 |
| Customer Contact # | No | Number | The customer's contact number identifier | 1 |
| Category | No | Text | The product's category | Food |
| County | No | Text | The county the tax rate applies to | Cook |
| State Tax Percentage | Yes | Number | The state's tax percentage | 6.25 |
| County Tax Percentage | No | Number | The county's tax percentage | 1.75 |
| Other Sales Tax 1 | No | Number | Other tax percentage to be added | 0.75 |
| Other Sales Tax 2 | No | Number | Other tax percentage to be added | 0.50 |
| Other Sales Tax 3 | No | Number | Other tax percentage to be added | 0.25 |
| Tax Freight? | Yes | Yes/No | Should tax calculations include freight charges? | Yes |