{"id":2393,"date":"2014-12-15T18:29:07","date_gmt":"2014-12-15T23:29:07","guid":{"rendered":"http:\/\/certek.com\/kb4\/?p=2393"},"modified":"2026-02-18T13:58:52","modified_gmt":"2026-02-18T18:58:52","slug":"external-accounting-package-settings","status":"publish","type":"ht_kb","link":"https:\/\/certek.com\/kb4\/knowledge-base\/external-accounting-package-settings\/","title":{"rendered":"External Accounting Package Settings"},"content":{"rendered":"\n<p class=\"wp-block-ht-blocks-messages wp-block-hb-message wp-block-hb-message--withicon is-style-info\">This article is part of a series on using <em>Artisan<\/em> with External Accounting Programs, such as QuickBooks. For the full series, see <strong><a href=\"https:\/\/certek.com\/kb4\/knowledge-base\/working-with-external-accounting-software\/\">Working with External Accounting Software<\/a><\/strong>.<br><br>Intuit and QuickBooks are registered trademarks of Intuit Inc. Used with permission.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Before you can export accounting data, you must configure Artisan&#8217;s <strong>External Accounting Package Settings<\/strong> to map to the appropriate accounts in the <strong>Chart of Accounts<\/strong> in your accounting program. This article describes those settings in detail. To learn more about Charts of Accounts, see <a href=\"https:\/\/certek.com\/kb4\/knowledge-base\/understanding-your-chart-of-accounts\/\" data-type=\"ht_kb\" data-id=\"23181\"><strong>Understanding Your Chart of Accounts<\/strong><\/a>.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-ht-blocks-messages wp-block-hb-message wp-block-hb-message--withicon is-style-alert\">We strongly recommend making a backup of your accounting program before testing changes to these settings with an export from Artisan. It&#8217;s easier to restore from a backup than to remove a bunch of incorrect imported transactions.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Before you begin, make sure you&#8217;ve turned on the External Accounting feature. See <a href=\"https:\/\/certek.com\/kb4\/knowledge-base\/turning-on-external-accounting\/\" data-type=\"ht_kb\" data-id=\"23242\"><strong>Turning On External Accounting<\/strong><\/a>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">From <strong>Tools => Options<\/strong>, click on \u201c<strong>Business and Financial Settings<\/strong>\u201d and then \u201c<strong>External Accounting Package Settings.<\/strong>&#8220;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">From here, you can configure your settings for exporting to external accounting programs like QuickBooks. These settings are associated with an &#8220;External Accounting Profile&#8221;. If you have just one set of External Accounting settings, you can use the default &#8220;Standard Profile&#8221;, if you want, or create a new one. If you need different settings for different sites (physical stores or online stores), you&#8217;ll need a separate profile for each site.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">To add a new profile, open the dropdown and click &#8220;<strong>Edit List.<\/strong>&#8220;<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2021\/12\/2021-12-22_10h42_20.png\"><img loading=\"lazy\" decoding=\"async\" width=\"735\" height=\"223\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2021\/12\/2021-12-22_10h42_20.png\" alt=\"\" class=\"wp-image-10107\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2021\/12\/2021-12-22_10h42_20.png 735w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2021\/12\/2021-12-22_10h42_20-300x91.png 300w\" sizes=\"auto, (max-width: 735px) 100vw, 735px\" \/><\/a><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Click &#8220;<strong>Add<\/strong>&#8221; and call this profile &#8220;<strong>QuickBooks<\/strong>&#8221; (or whatever). Click &#8220;<strong>OK<\/strong>.&#8221;<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2021\/12\/2021-12-22_10h42_20-1.png\"><img loading=\"lazy\" decoding=\"async\" width=\"735\" height=\"223\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2021\/12\/2021-12-22_10h42_20-1.png\" alt=\"\" class=\"wp-image-10172\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2021\/12\/2021-12-22_10h42_20-1.png 735w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2021\/12\/2021-12-22_10h42_20-1-300x91.png 300w\" sizes=\"auto, (max-width: 735px) 100vw, 735px\" \/><\/a><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Select your new profile from the &#8220;<strong>View\/Edit Settings<\/strong>&#8221; dropdown.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2021\/12\/2021-12-22_10h43_14-2.png\"><img loading=\"lazy\" decoding=\"async\" width=\"595\" height=\"478\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2021\/12\/2021-12-22_10h43_14-2.png\" alt=\"\" class=\"wp-image-10173\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2021\/12\/2021-12-22_10h43_14-2.png 595w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2021\/12\/2021-12-22_10h43_14-2-300x241.png 300w\" sizes=\"auto, (max-width: 595px) 100vw, 595px\" \/><\/a><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Next, from the &#8220;<strong>Accounting Program<\/strong>&#8221; dropdown, select &#8220;<strong>QuickBooks Desktop IIF File<\/strong>&#8221; or &#8220;<strong>QuickBooks Online (QBO)<\/strong>&#8220;, as appropriate.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2014\/12\/image-1.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"649\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2014\/12\/image-1-1024x649.png\" alt=\"\" class=\"wp-image-23245\" style=\"aspect-ratio:1.5778331591499852;width:826px;height:auto\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2014\/12\/image-1-1024x649.png 1024w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2014\/12\/image-1-300x190.png 300w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2014\/12\/image-1-768x487.png 768w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2014\/12\/image-1-50x32.png 50w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2014\/12\/image-1-1536x974.png 1536w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2014\/12\/image-1-2048x1298.png 2048w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2014\/12\/image-1-60x38.png 60w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2014\/12\/image-1-100x63.png 100w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p class=\"wp-block-ht-blocks-messages wp-block-hb-message wp-block-hb-message--withicon is-style-info\">If you select QuickBooks Online, you&#8217;ll need to connect to QuickBooks before you can export data. You can do that now or after you fill in the rest of the settings. See <a href=\"https:\/\/certek.com\/kb4\/knowledge-base\/connecting-to-quickbooks-online\/\" data-type=\"ht_kb\" data-id=\"22982\"><strong>Connecting to QuickBooks Online (QBO)<\/strong><\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Other general settings<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">There are a few settings in the top section in addition to the <strong>Accounting Program<\/strong> selection.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Default &#8220;Class&#8221; Name: <\/strong>Some accounting programs, including QuickBooks, support classes as a more fine-grained way to categorize transactions beyond accounts. This is often used to distinguish amounts for separate business entities or stores in a multi-store company. This optional setting allows you to specify a class to append to each account, but you can override this by putting a class name after a double percent-sign (&#8220;%%&#8221;) in any individual account setting. (For example, &#8220;Sales Income%%Store 2&#8221;). Leave this blank if you don&#8217;t use classes.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Include ALL Sites in One Export <em>(Multi-Site Only)<\/em>:<\/strong> Set this if you have multiple sites and want them all to be included in one accounting export (from any site), each with their own External Accounting Profile (usually distinguished by &#8220;Class&#8221; or an entirely separate set of account names).<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Include Date in Export Filename:<\/strong> For file-based exports, like QuickBooks Desktop, this appends the date (of the last included closing) to the default export filename, so you can keep multiple day&#8217;s copies in the same folder. For example, &#8220;DayEnd-YYYYMMDD.IIF&#8221; instead of &#8220;DayEnd.IIF&#8221;. This field is not shown for direct integrations such as QuickBooks Online.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\">The rest of the External Accounting Package Settings are divided into &#8220;<strong>Deposits and Bank Accounts<\/strong>,&#8221; &#8220;<strong>General Accounts<\/strong>,&#8221; &#8220;<strong>Inventory Adjustment Expense Accounts<\/strong>,&#8221; &#8220;<strong>Accounts Receivable<\/strong>,&#8221; and &#8220;<strong>Accounts Payable and Vendors<\/strong>&#8221; sections.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Each of these sections contains a number of fields corresponding to abstract accounts in <em>Artisan<\/em>, like &#8220;Primary Bank Account&#8221;, &#8220;Sales Income Account&#8221;, &#8220;Cost of Goods Account&#8221;, etc. Fill in the exact account name or number of a corresponding account in the Chart of Accounts for your external accounting program. If an appropriate account doesn&#8217;t already exist in your Chart of Accounts, you\u2019ll have to create a new one, and then fill in <em>that<\/em> name or number in <em>Artisan<\/em>.<\/p>\n\n\n\n<p class=\"wp-block-ht-blocks-messages wp-block-hb-message wp-block-hb-message--withicon is-style-info\">External Accounting Settings marked with a red asterisk are the most commonly used fields. You should make sure those are filled in (unless you definitely know some are not going to be used). In general, account settings are only required when an export includes transactions of that type.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Be sure to pick (or create) accounts of the correct type (Income, Expense, Asset, or Liability), as listed in the detailed description of each  <em>Artisan<\/em> configuration field. You can use the same account name\/number in multiple fields, if you want to combine multiple amounts into one account.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">If your accounting program uses sub-accounts, enter the whole &#8220;chain&#8221; of accounts, starting with the main account, with each level separated by a colon (&#8220;:&#8221;). For example, &#8220;Cost of Goods Sold:Shipping Cost&#8221;.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">If your accounting program uses &#8220;classes&#8221;, you can append a class name to each account (separated by &#8220;%%&#8221;), or use the Default &#8220;Class&#8221; Name setting, above, to use the same class for all accounts.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Deposits and Bank Accounts<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Primary Bank Account: <\/strong>This is the main bank account where your cash and checks are deposited. Often, credit card deposits go to the primary account as well, but this can be overridden based on Deposit Group numbers (see below).<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2021\/12\/2021-12-23_09h55_39.png\"><img loading=\"lazy\" decoding=\"async\" width=\"706\" height=\"445\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2021\/12\/2021-12-23_09h55_39.png\" alt=\"\" class=\"wp-image-10176\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2021\/12\/2021-12-23_09h55_39.png 706w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2021\/12\/2021-12-23_09h55_39-300x189.png 300w\" sizes=\"auto, (max-width: 706px) 100vw, 706px\" \/><\/a><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">In the next section you can change which bank account different payment types go to, based on their Deposit Group numbers. You can also set them to be left in the &#8220;Undeposited Funds&#8221; account, if you want to record deposits manually in QuickBooks.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2021\/12\/2021-12-22_12h38_01-1.png\"><img loading=\"lazy\" decoding=\"async\" width=\"714\" height=\"505\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2021\/12\/2021-12-22_12h38_01-1.png\" alt=\"\" class=\"wp-image-10177\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2021\/12\/2021-12-22_12h38_01-1.png 714w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2021\/12\/2021-12-22_12h38_01-1-300x212.png 300w\" sizes=\"auto, (max-width: 714px) 100vw, 714px\" \/><\/a><figcaption class=\"wp-element-caption\"><strong>Deposit Groups<\/strong> allow you to group Payment Types that are deposited together. (For example, Cash &amp; Check vs Credit Cards.)<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">You can control which Payment Types are included in which Deposit Group by going to <strong><em>&#8220;Payment Types &amp; A\/R Terms&#8221;<\/em><\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2021\/12\/2021-12-23_12h12_49.png\"><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"404\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2021\/12\/2021-12-23_12h12_49.png\" alt=\"\" class=\"wp-image-10202\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2021\/12\/2021-12-23_12h12_49.png 700w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2021\/12\/2021-12-23_12h12_49-300x173.png 300w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/a><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Deposit Modes: <\/strong>Each Deposit Group has a selector for a &#8220;Deposit Mode.&#8221; There are three deposit modes to choose from: &#8220;<strong>Leave in Undeposited Funds<\/strong>,&#8221; &#8220;<strong>Deposit to Primary Bank Account<\/strong>,&#8221; and &#8220;<strong>Deposit to a Specified Bank Account<\/strong>.&#8221; Normally, you&#8217;ll leave your deposit groups set to &#8220;<strong>Deposit to Primary Bank<\/strong>.&#8221; But there are exceptions.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">For example, let&#8217;s say you want your credit card deposits to go into a specific account or group (let&#8217;s say Group #3). Click on the dropdown for &#8220;<strong>Deposit Group 3<\/strong>&#8221; and change it to &#8220;<strong>Deposit to Specified Bank Account<\/strong>,&#8221; then enter the corresponding account name\/number from your chart of accounts.  (For example, &#8220;A &amp; C:New York &#8211; Credit Card.&#8221;)<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2021\/12\/2021-12-22_12h50_42-1.png\"><img loading=\"lazy\" decoding=\"async\" width=\"669\" height=\"370\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2021\/12\/2021-12-22_12h50_42-1.png\" alt=\"\" class=\"wp-image-10204\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2021\/12\/2021-12-22_12h50_42-1.png 669w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2021\/12\/2021-12-22_12h50_42-1-300x166.png 300w\" sizes=\"auto, (max-width: 669px) 100vw, 669px\" \/><\/a><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2021\/12\/2021-12-22_12h44_21-2.png\"><img loading=\"lazy\" decoding=\"async\" width=\"722\" height=\"412\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2021\/12\/2021-12-22_12h44_21-2.png\" alt=\"\" class=\"wp-image-10205\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2021\/12\/2021-12-22_12h44_21-2.png 722w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2021\/12\/2021-12-22_12h44_21-2-300x171.png 300w\" sizes=\"auto, (max-width: 722px) 100vw, 722px\" \/><\/a><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">If you want to record deposits manually in your accounting program (where supported), set the corresponding groups to &#8220;<strong>Leave in Undeposited Funds<\/strong>,&#8221; and fill in the &#8220;Undeposited Funds Account&#8221; field with the name\/number of that account (which, for QuickBooks, will typically be &#8220;Undeposited Funds&#8221;).<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2021\/12\/2021-12-22_12h52_04-1.png\"><img loading=\"lazy\" decoding=\"async\" width=\"666\" height=\"376\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2021\/12\/2021-12-22_12h52_04-1.png\" alt=\"\" class=\"wp-image-10207\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2021\/12\/2021-12-22_12h52_04-1.png 666w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2021\/12\/2021-12-22_12h52_04-1-300x169.png 300w\" sizes=\"auto, (max-width: 666px) 100vw, 666px\" \/><\/a><\/figure>\n\n\n\n<p class=\"wp-block-ht-blocks-messages wp-block-hb-message wp-block-hb-message--withicon is-style-info\">Deposits are recorded as separate individual transactions so they can be matched to bank feeds and can be separately marked as &#8220;cleared&#8221; when they&#8217;re reconciled against bank statements.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2021\/12\/image-7.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"398\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2021\/12\/image-7-1024x398.png\" alt=\"\" class=\"wp-image-23166\" style=\"width:657px;height:auto\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2021\/12\/image-7-1024x398.png 1024w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2021\/12\/image-7-300x117.png 300w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2021\/12\/image-7-768x299.png 768w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2021\/12\/image-7-50x19.png 50w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2021\/12\/image-7-60x23.png 60w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2021\/12\/image-7-100x39.png 100w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2021\/12\/image-7.png 1276w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Undeposited Funds Account:<\/strong> Use this Current Asset account if you&#8217;ve set any deposit groups to be left as Undeposited Funds. For QuickBooks, this should be the built-in account named &#8220;Undeposited Funds.&#8221;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Generic Customer Name:<\/strong> If you&#8217;re using Undeposited Funds, set this to &#8220;Customer&#8221; or some other generic name to use when any undeposited tenders have no name associated with their sales in <em>Artisan<\/em> or aren&#8217;t itemized. (See &#8220;Itemize Cash &amp; Check Deposits.&#8221;)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Deposit Clearing Account:<\/strong> Use this Current Asset account if you have any deposit groups that are <em><span style=\"text-decoration: underline;\">not<\/span><\/em> left as Undeposited Funds. You&#8217;ll probably have to create a new account for this in your Chart of Accounts. This account is used to transfer amounts from the overall &#8220;Daily Sales&#8221; journal entry to the Deposit transactions for the specific bank account(s), and should always net to zero.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Transaction Type for Recording Deposits:<\/strong> There are several options for how to record deposits in your accounting program. For QuickBooks, the best choice is <strong>&#8220;Deposit if Positive, Else Journal&#8221;<\/strong>, since QuickBooks does not allow negative deposits. Other options are to always record as a <strong>Journal Entry<\/strong> or always record as a <strong>Deposit<\/strong>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Itemize Cash &amp; Check Deposits:<\/strong> Select &#8220;Yes&#8221; to itemize deposits containing Cash and\/or Checks to show each check on its own split line, with check details (if available) like check number and name (with one line for Cash). This itemization applies to both the &#8220;Daily Sales&#8221; Journal Entry and any created Deposit transaction(s).<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Cash On Hand Account:<\/strong> This is a Current Asset account used to reflect any cash left in drawers or a store safe after bank deposits, if you use the Cash Counter to reduce the amount of the cash deposit at the end of the day.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">General Accounts<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The next section is the &#8220;<strong>General Accounts<\/strong>&#8221; section.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2021\/12\/2021-12-23_12h24_13.png\"><img loading=\"lazy\" decoding=\"async\" width=\"671\" height=\"440\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2021\/12\/2021-12-23_12h24_13.png\" alt=\"\" class=\"wp-image-10210\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2021\/12\/2021-12-23_12h24_13.png 671w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2021\/12\/2021-12-23_12h24_13-300x197.png 300w\" sizes=\"auto, (max-width: 671px) 100vw, 671px\" \/><\/a><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Sales Tax Account &amp; Payee:<\/strong> When you collect Sales Tax, you don\u2019t pay it to the state daily, so this is the account that accumulates your sales tax due into a Current Liability account (often called &#8220;Sales Tax Payable&#8221;). Make sure to also fill in the <strong>Payee Name<\/strong> (required by QuickBooks). This is the name of the tax authority to whom you will write checks for Sales Tax. It&#8217;s critical that you enter this name correctly and that it exactly match the name configured in your accounting program.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Sales Income Account&nbsp;<\/strong>&#8211;&nbsp;Enter the external account name or number to use for Sales Income&nbsp;(unless overridden by a Category record, when Allow Category Overrides is set). This will&nbsp;be Net Sales Income if the general Sales Discount Account is blank; otherwise it will be&nbsp;Gross Sales Income. This includes sales of both owned and consignment items, unless you&nbsp;configure a Consignment Sales Income account (see below).<\/p>\n\n\n\n<p class=\"wp-block-ht-blocks-messages wp-block-hb-message wp-block-hb-message--withicon is-style-info\"><strong>Allow Category Overrides (Yes\/No):<\/strong> Several account fields have an option to further break down your accounts by Category. Set this to Yes to allow it that. You can then configure specific accounts in the &#8220;External Accounts&#8221; tab of each <em>Arisan<\/em> Category Record. Any category-based fields left blank will be inherited from their parent category; if blank in the whole category hierarchy, then the main account setting will be used.<br><br>Similarly, the Accounts Payable Account can <strong>Allow Vendor Overrides<\/strong>.<br><br>However, since you can run breakdown reports from Artisan, breaking accounts down by Category or Vendor is often overkill.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Consignment Sales Account:<\/strong> Use this if you want to separate out your consignment sales income on the accounting side. This will be Net Consignment Sales Income if the general&nbsp;Sales Discount Account is blank; otherwise it will be Gross Consignment Sales Income. If&nbsp;this setting is left blank, consignment sales income will be included in the general Sales&nbsp;Income Account (or corresponding Category-specific account, if overrides are allowed). Either way, <em>Artisan<\/em> has some reports that distinguish consignment sales vs regular sales, so you don&#8217;t <em>need<\/em> to separate them in your accounting program.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Sales Discount Account:<\/strong> Normally, <em><span style=\"text-decoration: underline;\">Net<\/span><\/em> Sales Income is exported to the Sales Income account, but if you want, you can specify a Sales Discount Account here. In that case the Sales Income export will be the <em><span style=\"text-decoration: underline;\">Gross<\/span><\/em> (pre-discount) Sales Income.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Non-Sales Income Account:<\/strong> Use this to record Non-Sales Income (&#8220;Other Income&#8221;) from sales of items in Non-Sales categories.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Cost of Goods Account:<\/strong> Cost of Goods Sold or <strong>COGS<\/strong> is an accounting term, and it is the raw cost of normal and consignment sales, normally excluding transportation costs. Transportation costs may be included if Artisan has been configured to do so, but most businesses need to immediately expense the transportation costs. QuickBooks often creates this account for you, and they even have a Cost of Goods account type, which is a special category of Current Assets. <strong><a href=\"https:\/\/quickbooks.intuit.com\/r\/bookkeeping\/cost-of-goods-sold\/\" target=\"_blank\" rel=\"noreferrer noopener\">Understanding how Cost of Goods works<\/a> <\/strong>is integral to accounting for sales of inventory.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">It is critical to understand that when you purchase inventory, it goes into an <strong>Inventory Asset account<\/strong>. It is never considered an expense until the merchandise is sold. Artisan will move the cost amount from the Inventory Asset to Cost of Goods Sold as sales are marked delivered. Most sales are automatically marked delivered except special orders and deferred shipping.<\/p>\n\n\n\n<p class=\"wp-block-ht-blocks-messages wp-block-hb-message wp-block-hb-message--withicon is-style-info\">At a high level, <strong>Cost of Goods Sold = Beginning Inventory + Purchases \u2013 Adjustments \u2013 Ending Inventory<\/strong>.<br><br>However, <em>Artisan<\/em> implements a &#8220;perpetual inventory&#8221; model, exporting incremental changes to <strong>Inventory Asset<\/strong>, <strong>Cost of Goods Sold<\/strong>, and (if appropriate) <strong>Inventory Adjustments<\/strong> during each export.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Consignment Cost Account:<\/strong> Use this if you want to separate out your consignment COGS on the accounting side. If you leave this field blank, then Consignment Cost will be included in the Cost of Goods Sold account. Either way, <em>Artisan<\/em> has some reports that distinguish cost of consignment sales vs regular sales, so you don&#8217;t <em>need<\/em> to separate them in your accounting program.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Inventory Asset Account:<\/strong> This is a required account if you have any owned (non-consignment) inventory. Artisan adds and subtracts from your inventory asset value as items are invoiced, sold, or adjusted. Note that just receiving inventory will NOT increase this value. You must either use Vendor Invoices or manually enter your invoices into QuickBooks. It works this way so you don\u2019t double enter your inventory. Ultimately you have to pay for that inventory and when you do, it becomes an Inventory Asset in QuickBooks. See Also Cost of Goods and Accounts Payable.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Cash (etc) Over \/ Short:<\/strong> Often we have cash (and occasionally other payment types) that are over or under what we are expecting. During the Day End process, you can make adjustments and this is the account where that goes. This account should be an Income or Expense account. (It will be income when net positive and an expense when negative.)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Cash Rounding Account:<\/strong> If you&#8217;re using the Cash Rounding feature (also known as Penny Rounding), this account accumulates the corresponding adjustment income\/expense. Often this will be the same account as Cash (etc) Over \/ Short. It should be an Income or Expense account. (It will be income when net positive and an expense when negative.)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Gift Card Liability Account:<\/strong> When a GC (Gift Card or Gift Certificate) is issued, it is <em><span style=\"text-decoration: underline;\">not<\/span><\/em> considered a sale. There is no sales tax due and nothing to report as sales. Instead, it counts as a Current Liability. Once the GC is redeemed, the liability is reduced. The GC is applied as payment on the merchandise sale, but it is that merchandise sale itself that counts as Sales Income and incurs Sales Tax, not the GC. On the Sales Summary report this total can go up or down depending on the activity. This account would theoretically zero out eventually, but inevitably some GCs will never get redeemed.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>GC Discount Expense Account:<\/strong> When a GC is issued at a discount, the discount amount will be sent to this expense account.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Check Pay-Out Account:<\/strong> This Expense account records checks paid to customers (for refunds or Buy From Customer transactions) or for miscellaneous pay-outs from the Sale Screen.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Customer Deposits Account:<\/strong> When you enter a layaway, sales order, special order, custom order, or deferred shipping (manually mark shipped orders delivered) then, until it&#8217;s marked delivered, it&#8217;s not counted as a sale and sales tax is not due. Any deposit or additional payments made are held in this Current Liability account until the layaway\/order is marked delivered and treated as a sale. At that time, the Customer Deposits account is reduced. Similarly to the GC Liability Account, this account will theoretically zero out eventually.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Store Credit Account:<\/strong> This is another Current Liability account, similar to Gift Card Liability and Customer Deposits. It represents the liability for Store Credits issued but not yet redeemed.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Tips (Gratuity) Account:<\/strong> This Current Liability account hold tips received but not yet paid out to employees. Note that <em>Artisan<\/em> handles the collection of tips, but it does <em><span style=\"text-decoration: underline;\">not<\/span><\/em> handle tip payments to employees. Employee payments must be handled outside of <em>Artisan<\/em> and recorded manually in your accounting program (by reducing the amount in this account by the amount paid, typically zeroing it out).<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Inventory Adjustment Accounts<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">When merchandise is given away, used in house, destroyed, or otherwise taken out of inventory w\/o selling, or added to inventory w\/o receiving, the resulting reductions or increases in inventory asset value can be exported to specific expense accounts, rather than being lumped into Cost of Goods Sold. (These could be made sub-accounts of COGS if you want to do it that way.)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">You could choose to have a single Inventory Adjustment account, and set all of the Inventory Adjustment Expense Accounts fields to that account. However, we recommend splitting the different types of adjustments into separate accounts or sub-accounts, as shown below, to give your accountant more visibility into the reasons for the adjustments.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">All of these should be Expense accounts. DO NOT use the Inventory Asset account here. All of these transactions will also include an equal and opposite corresponding adjustment to the Inventory Asset account.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2021\/12\/2021-12-23_14h40_06.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"244\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2021\/12\/2021-12-23_14h40_06-1024x244.png\" alt=\"\" class=\"wp-image-10270\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2021\/12\/2021-12-23_14h40_06-1024x244.png 1024w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2021\/12\/2021-12-23_14h40_06-300x71.png 300w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2021\/12\/2021-12-23_14h40_06-768x183.png 768w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2021\/12\/2021-12-23_14h40_06-1536x365.png 1536w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2021\/12\/2021-12-23_14h40_06.png 2022w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Shrinkage Account:<\/strong> Technically this is inventory that has been lost or stolen, but during a physical inventory any shortages are classified in this category. If you know that you failed to record a Donation, for example, make sure to enter that into <em>Artisan<\/em> <em><span style=\"text-decoration: underline;\">before<\/span><\/em> performing a physical inventory.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Destroyed Inventory Account:<\/strong> Anytime something is broken or damaged beyond the ability to sell it at a discount, then it is written off as an expense (unless the vendor takes responsibility for it). If you are returning defective merchandise, use Return to Vendor instead.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Internal Use Account:<\/strong> If you consume some of your product in the process of selling them, then that is considered Internal Use. For example, if you sell candles and you actually burn some of them as demonstration. The same is true if sell paper towels and you use some of them to clean your counter. You must take them out of inventory using an Internal Use adjustment; you can\u2019t just go pull them off the shelf as needed. Also note that <em>Artisan<\/em> does not compute or report any Use Tax that might be due as a result of Internal Use; it&#8217;s your responsibility to handle that outside of <em>Artisan<\/em>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Donated Inventory Account:<\/strong> When you give away merchandise to a charity or participate in a charitable promotion, and record it as a Donation, it&#8217;s recorded using this Expense account. Consult your accountant to determine whether donations are tax deductible.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Other Inventory Adjustment Account:<\/strong> Any type of inventory adjustment not listed above is exported to this expense account.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Accounts Receivable (A\/R) Accounts<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">If you use the House Accounts or Full A\/R features, then this group of accounts comes into play.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2021\/12\/2021-12-23_14h49_43.png\"><img loading=\"lazy\" decoding=\"async\" width=\"672\" height=\"199\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2021\/12\/2021-12-23_14h49_43.png\" alt=\"\" class=\"wp-image-10272\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2021\/12\/2021-12-23_14h49_43.png 672w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2021\/12\/2021-12-23_14h49_43-300x89.png 300w\" sizes=\"auto, (max-width: 672px) 100vw, 672px\" \/><\/a><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Accounts Receivable Account:<\/strong> All A\/R funds go through this Current Asset account. (In QuickBooks, it may be the built-in special &#8220;Accounts Receivable&#8221; account.) This account holds the balance of your open accounts; individual transactions may increase or decrease this balance as sales are charged and paid off.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Finance Charge Income Account:<\/strong> Finance charges are recorded with this Income account.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Late Fee Income Account:<\/strong> Late fees are are recorded with this Income account. Often set to the same account as Finance Charges.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Manual A\/R Adjustment Account:<\/strong> If you change a customer&#8217;s A\/R balance directly, in the Customer Record, without a new charge or payment, it will be recorded as a Manual A\/R Adjustment (offset by an equal and opposite change to the Accounts Receivable Account). This is an Income account. When it is necessary to edit the A\/R balance field directly rather than through a sale or a return. This could be one way to write off bad debt and therefor this account is an Expense in QuickBooks.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Create Individual A\/R Transactions (Yes\/No):<\/strong> Normally, all A\/R (Accounts Receivable) transactions (new charges and payments) for all customers are lumped into a single Net A\/R line in the Daily Sales summary transaction. If you select \u201cYes\u201d here, you\u2019ll instead get a separate A\/R transaction for each customer with any A\/R activity on that day. This lets you track individual A\/R balances in your accounting package. It does <em><span style=\"text-decoration: underline;\">not<\/span><\/em> let you produce detailed A\/R statements in your accounting program. <em>Artisan<\/em> is responsible for generating and printing A\/R statements.<\/p>\n\n\n\n<p class=\"wp-block-ht-blocks-messages wp-block-hb-message wp-block-hb-message--withicon is-style-alert\">If using the built-in &#8220;Accounts Receivable&#8221; account in QuickBooks, you <em><span style=\"text-decoration: underline;\">must<\/span><\/em> enable Individual A\/R Transactions. QuickBooks doesn&#8217;t allow that account to be used without a Payee.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>A\/R Clearing Account:<\/strong> When using Individual A\/R Transactions, this account is used as a temporary clearing account for the A\/R amounts to move them from the Daily Sales journal entry to the individual transactions. Like the Deposit Clearing Account, this is a Current Asset account and should always net to zero. It&#8217;s often set to the same account as the Deposit Clearing Account.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Accounts Payable &amp; Vendor Accounts<\/h2>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2021\/12\/image-4.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"173\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2021\/12\/image-4-1024x173.png\" alt=\"\" class=\"wp-image-23158\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2021\/12\/image-4-1024x173.png 1024w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2021\/12\/image-4-300x51.png 300w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2021\/12\/image-4-768x130.png 768w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2021\/12\/image-4-50x8.png 50w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2021\/12\/image-4-60x10.png 60w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2021\/12\/image-4-100x17.png 100w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2021\/12\/image-4.png 1312w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>A\/P Export Mode:<\/strong> This setting determines which type(s) of Accounts Payable transactions, if any, are exported:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2021\/12\/41283e8a-00a0-4ba4-8993-919e98239cc3.png\"><img loading=\"lazy\" decoding=\"async\" width=\"901\" height=\"156\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2021\/12\/41283e8a-00a0-4ba4-8993-919e98239cc3.png\" alt=\"\" class=\"wp-image-13425\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2021\/12\/41283e8a-00a0-4ba4-8993-919e98239cc3.png 901w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2021\/12\/41283e8a-00a0-4ba4-8993-919e98239cc3-300x52.png 300w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2021\/12\/41283e8a-00a0-4ba4-8993-919e98239cc3-768x133.png 768w\" sizes=\"auto, (max-width: 901px) 100vw, 901px\" \/><\/a><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Accounts Payable Account:<\/strong> This is a Current Liability account (or special Accounts Payable account) used to record payments due to vendors for Vendor Invoices and\/or Consignment Statements. If <strong>Allow Vendor Overrides<\/strong> is set to Yes, this account can be overridden by accounts set in individual Vendor Records.<\/p>\n\n\n\n<p class=\"wp-block-ht-blocks-messages wp-block-hb-message wp-block-hb-message--withicon is-style-info\">Accounts Payable amounts exported to QuickBooks (Vendor Invoices or Consignment Statements) are recorded as <strong>Bills Due<\/strong>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Shipping Cost Account:<\/strong> This account receives the Expense for inbound shipping (freight) costs associated with any exported Vendor Invoices, if <span style=\"text-decoration: underline;\"><em>not<\/em><\/span> distributed to individual units as part of Cost of Goods Sold. See the <strong>Shipping Cost Distribution<\/strong> setting under General Business Settings.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Before you can export accounting data, you must configure Artisan&#8217;s External Accounting Package Settings to map to the appropriate accounts in the Chart of Accounts in your accounting program. This article describes those settings in detail. To learn more about Charts of Accounts, see Understanding Your Chart of Accounts. Before&#8230;<\/p>\n","protected":false},"author":3,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"_eb_attr":"","_monsterinsights_skip_tracking":false,"footnotes":"","_members_access_role":[],"_members_access_error":""},"ht-kb-category":[370,410],"ht-kb-tag":[420,424,425,427],"class_list":["post-2393","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-business-and-financial-settings","ht_kb_category-external-accounting","ht_kb_tag-configuration","ht_kb_tag-quickbooks","ht_kb_tag-qbo","ht_kb_tag-accounting"],"_links":{"self":[{"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/ht-kb\/2393","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/comments?post=2393"}],"version-history":[{"count":20,"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/ht-kb\/2393\/revisions"}],"predecessor-version":[{"id":23252,"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/ht-kb\/2393\/revisions\/23252"}],"wp:attachment":[{"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/media?parent=2393"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/ht-kb-category?post=2393"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/ht-kb-tag?post=2393"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}