{"id":7392,"date":"2025-12-09T17:51:09","date_gmt":"2025-12-09T23:51:09","guid":{"rendered":"https:\/\/librarytestdev.wpenginepowered.com\/?post_type=doc&#038;p=7392"},"modified":"2026-01-06T18:38:37","modified_gmt":"2026-01-07T00:38:37","slug":"uploading-an-account-cash-balance-file","status":"publish","type":"doc","link":"https:\/\/library-staging.tradingtechnologies.com\/setup\/risk-management\/risk-administration\/task-risk-administration\/uploading-an-account-cash-balance-file\/","title":{"rendered":"Uploading an account cash balance file"},"content":{"rendered":"\n<!-- pages using refernce-tab-list layout will not trigger this condition. The Heading will be set in that layout file-->\n\n  \n    \n\n\n <!-- pages using refernce-tab-list layout will not trigger this condition. The Heading will be set in that layout file-->\n\n  \n    \n\n\n <!-- pages using refernce-tab-list layout will not trigger this condition. The Heading will be set in that layout file-->\n\n  \n    \n\n\n <!-- pages using refernce-tab-list layout will not trigger this condition. The Heading will be set in that layout file-->\n\n  \n    \n\n\n <!-- pages using refernce-tab-list layout will not trigger this condition. The Heading will be set in that layout file-->\n\n  \n    \n\n\n <!-- pages using refernce-tab-list layout will not trigger this condition. The Heading will be set in that layout file-->\n\n  \n    \n\n\n <!-- pages using refernce-tab-list layout will not trigger this condition. The Heading will be set in that layout file-->\n\n  \n     <!-- in source YML header, should also match the filename\/url -->\n       \n        \n\n        \n      \n          \n      \n\n\n <!-- pages using refernce-tab-list layout will not trigger this condition. The Heading will be set in that layout file-->\n\n  \n    \n\n\n\n\n\n\n\n\n\n\n            <div>\n\n\t<p>As a Company Administrator, you can use the <b>Data Uploads<\/b> page to upload cash balances data from the following file format: \n\t<\/p><ul>\n\t\t<li><a href=\"rm-file-layouts.html#cash\">CSV<\/a><\/li>\n\t<\/ul>\n\n\n<p>There are options to select Account Cash Balance file or Risk Group Cash Balance file<\/p>\n\n<p>Each cash balance file includes your company&#8217;s account names, currency, and cash balances. When uploaded, the Setup app reads the values of the file and assigns the cash balances to accounts in your Company. Cash balances can be uploaded to parent, child, or shared accounts as long as they are owned by your Company.<\/p>\n\n<p>To upload an account credit file&#8230;<\/p>\n\n<ol>\n\n<li>Click <b>Company Settings<\/b> | <b>Data Uploads<\/b> in left navigation pane.<\/li>\n<li>Click <b>+ New Upload<\/b>.\n<\/li><li>In the <b>Upload File<\/b> dialog box, select a cash balance file type and file format, click <b>Choose file<\/b> to browse to and select a file.<\/li>\n<li>Optionally, check <b>Continue on Error<\/b>. \n<p>When this option is checked (enabled), Setup continues uploading data regardless of how many upload errors may be logged and shown in the <b>Upload Errors<\/b> section. By default, this option is unchecked (disabled) and the upload stops when the first error is detected.\n<\/p>\n\n<\/li>\n\n\n<li>Click <b>Upload<\/b>. \n\n\t<p><img decoding=\"async\" class=\"img-responsive\" src=\"https:\/\/library-staging.tradingtechnologies.com\/wp-content\/uploads\/2025\/12\/deb-ttus-cash-balance-upload-file.png\"> <\/p>\n\n\t<p>A record of the uploaded file and its status appears in the grid. Click the checkbox next to the record to review the <b>Output<\/b> section, which displays how many rows of the file are processed. Any errors that occur during the upload will appear in an <b>Error<\/b> section on this page.<\/p>\n\n<p><b>Note<\/b>: If there are multiple rows in the cash balance file, the last row will overwrite the first.<\/p>\n\n\t<\/li>\n\n<\/ol>\n\n<h2>Column names for CSV (Cash Balances &#8211; Accounts)<\/h2>\n\n<p>&#8220;Account&#8221;, &#8220;SOD Cash&#8221;, &#8220;Currency&#8221;, &#8220;Sec Collateral 1&#8221;, &#8220;Sec Collateral 2&#8221;, &#8220;Open Trade Equity&#8221;, &#8220;Long Option Value&#8221;,\t&#8220;Short Option Value&#8221;, &#8220;Liquidating Value&#8221;, &#8220;Total Equity&#8221;,\t&#8220;Initial Margin&#8221;, &#8220;Maintenance Margin&#8221;<\/p>\n\n\n<h2>Column names for CSV (Cash Balances &#8211; Risk Groups)<\/h2>\n\n<p>&#8220;Risk Group Name&#8221;, &#8220;SOD Cash&#8221;, &#8220;Currency&#8221;, &#8220;Sec Collateral 1&#8221;, &#8220;Sec Collateral 2&#8221;, &#8220;Open Trade Equity&#8221;, &#8220;Long Option Value&#8221;,\t&#8220;Short Option Value&#8221;, &#8220;Liquidating Value&#8221;, &#8220;Total Equity&#8221;,&#8221;Initial Margin&#8221;,\t&#8220;Maintenance Margin&#8221;<\/p>\n\n\n<div><h2>Deleting an Account Credit File<\/h2>\n\n<p>To delete an account credit file, click <b>Data Uploads<\/b>, click the checkbox next to the record and click <b>Delete<\/b>. The system will prompt you to confirm that you want to delete the file. After deleting the file, the Setup app removes the credit limit from all accounts listed in the file.<\/p>\n\n<\/div>\n\n\n\n\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>As a Company Administrator, you can use the Data Uploads page to upload cash balances data from the following  [&hellip;]<\/p>\n","protected":false},"author":2,"template":"","meta":{"_acf_changed":false,"footnotes":""},"docs-category":[547],"class_list":["post-7392","doc","type-doc","status-publish","hentry","docs-category-task-risk-administration"],"acf":[],"_links":{"self":[{"href":"https:\/\/library-staging.tradingtechnologies.com\/ja\/wp-json\/wp\/v2\/doc\/7392","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/library-staging.tradingtechnologies.com\/ja\/wp-json\/wp\/v2\/doc"}],"about":[{"href":"https:\/\/library-staging.tradingtechnologies.com\/ja\/wp-json\/wp\/v2\/types\/doc"}],"author":[{"embeddable":true,"href":"https:\/\/library-staging.tradingtechnologies.com\/ja\/wp-json\/wp\/v2\/users\/2"}],"version-history":[{"count":0,"href":"https:\/\/library-staging.tradingtechnologies.com\/ja\/wp-json\/wp\/v2\/doc\/7392\/revisions"}],"wp:attachment":[{"href":"https:\/\/library-staging.tradingtechnologies.com\/ja\/wp-json\/wp\/v2\/media?parent=7392"}],"wp:term":[{"taxonomy":"docs-category","embeddable":true,"href":"https:\/\/library-staging.tradingtechnologies.com\/ja\/wp-json\/wp\/v2\/docs-category?post=7392"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}