SEC Form 13F - Self-file Portal
13f.acii.com
a division of Advanced Computer Innovations, Inc.
70 Office Park Way • Pittsford, NY 14534-1746 (USA)
Phone: (585)-385-3810 • Email: click here
How it works
This portal lets you easily create the 13F XML Information Table from your Excel or other spreadsheets, with EDGAR validation guaranteed. Just follow these simple steps: 1. No need to redo your holdings table spreadsheet(s). You only need the relevant columns to have the following heading labels (shown bold): • CUSIP - uniquely identifies each security • Quantity - shares, or principal amount • Value - market value (in dollars) • Security - name of the security 1 • Type - type of security 1 • FIGI - financial instrument global identifier 2 • Ticker - ticker symbol 3 • ShPrn - shares (SH) or principal (PRN) 4 • PutCall - required only for options • InvDiscretion - sole/defined/other 5 • ISole - sole investment discretion (shares) 5 • IDefined - defined investment discretion (shares) 5 • IOther - other investment discretion (shares) 5 • OtherManagers - index numbers 6 • VotingAuthority - sole/shared/none 7 • VSole - sole voting authority (shares) 7 • VShared - shared voting authority (shares) 7 • VNone - no voting authority (shares) 7 Columns may be in any order. CUSIP, Quantity and Value are the only required columns. The other columns may be omitted if default values are appropriate. Extra columns having other labels are ignored. Click here to download a sample Excel file. 2. Remove extra rows from the table, leaving column headings in the first row followed by security entries and nothing else. Change all cell formats to text 8 and save as a comma-separated (.csv) file. 3. If you have multiple tables, do the above for each of them, then combine all the .csv files into a .zip file. 4. In the SEC Form 13F Self-Service box, fill in or edit any fields as needed and click Show Free Preview and Cost. The scrubbed and aggregated information table will display in a couple of seconds, along with the exact cost to produce the XML file. 5. Examine and check the information table. Once satisfied with the results, fill in your credit/debit card details in the Secure Payment box and click Pay and Download XML Table. The XML table, ready for submission, will download to your computer in a couple of seconds. 6. Log in to the SEC filing website, fill in the 13F cover sheet, attach the 13F table and submit your filing. Done! Questions or need additional help? Email us, or call 585-385-3810. ___________________________ 1 Security and Type columns are not required since the service gets these values from the SEC 13F list. If there, these columns are ignored unless the Use entries ‘as is’ checkbox is checked in the submission form. 2 As per SEC guidelines, FIGI is optional.. 3 The Ticker column is not required. If you have this column, the symbols are included in the proof for your reference. 4 If there is no ShPrn column. the Default Shares/Principal value from the submission form is used for the entire table. If you have this column but some cells in it are blank, the default value is used for those cells. 5 Your table should either have the InvDiscretion column (which specifies sole/defined/other discretion for all shares in a line item), or ISole, IDefined and IOther columns which specify the number of shares in each category. If none of these four columns exist, then the Default Investment Discretion value from the submission form applies to all shares in the entire table. If the InvDiscretion column exists but some cells in it are blank, the default value is used for those cells. If your table has ISole, IDefined and IOther columns, the service breaks out the shares into multiple rows to satisfy the SEC Information Table layout. 6 Index numbers in the OtherManagers column refer to correspondng numbers in the 13F cover sheet. If your table does not have this column, the Default Other Managers value from the submission form is used for the entire table. If you have this column but some cells in it are blank, the default value is used for those cells. The value may be blank if there are no other managers. 7 Your table should either have the VotingAuthority column (which specifies sole/shared/none authority for all shares in a line item), or VSole, VShared and VNone columns which specify the number of shares in each category. If none of these four columns exist, then the Default Voting Authority value from the submission form applies to all shares in the entire table. If the VotingAuthority column exists but some cells in it are blank, the default value is used for those cells. If your table does not have VSole, VShared and VNone columns, the service automatically creates them to satisfy the SEC Information Table layout. 8 Some CUSIPs look like floating point numbers to Excel, and it may reformat them when saving to a CSV file, which renders them invalid. Changing cell formats to text prevents this.
Copyright © Advanced Computer Innovations, Inc., 2023
Last updated 2023-02-07
a
SEC Form 13F - Self-file Portal
13f.acii.com
a division of Advanced Computer Innovations, Inc.
70 Office Park Way • Pittsford, NY 14534-1746 (USA)
Phone: (585)-385-3810 • Email: click here
Copyright © Advanced Computer Innovations, Inc., 2023
Last updated 2023-02-07
How it works
This portal lets you easily create the 13F XML Information Table from your Excel or other spreadsheets, with EDGAR validation guaranteed. Just follow these simple steps: 1. No need to redo your holdings table spreadsheet(s). You only need the relevant columns to have the following heading labels (shown bold): • CUSIP - uniquely identifies each security • Quantity - shares, or principal amount • Value - market value (in dollars) • Security - name of the security 1 • Type - type of security 1 • FIGI - financial instrument global identifier 2 • Ticker - ticker symbol 3 • ShPrn - shares (SH) or principal (PRN) 4 • PutCall - required only for options • InvDiscretion - sole/defined/other 5 • ISole - sole investment discretion (shares) 5 • IDefined - defined investment discretion (shares) 5 • IOther - other investment discretion (shares) 5 • OtherManagers - index numbers 6 • VotingAuthority - sole/shared/none 7 • VSole - sole voting authority (shares) 7 • VShared - shared voting authority (shares) 7 • VNone - no voting authority (shares) 7 Columns may be in any order. CUSIP, Quantity and Value are the only required columns. The other columns may be omitted if default values are appropriate. Extra columns having other labels are ignored. Click here to download a sample Excel file. 2. Remove extra rows from the table, leaving column headings in the first row followed by security entries and nothing else. Change all cell formats to text 8 and save as a comma-separated (.csv) file. 3. If you have multiple tables, do the above for each of them, then combine all the .csv files into a .zip file. 4. In the SEC Form 13F Self-Service box, fill in or edit any fields as needed and click Show Free Preview and Cost. The scrubbed and aggregated information table will display in a couple of seconds, along with the exact cost to produce the XML file. 5. Examine and check the information table. Once satisfied with the results, fill in your credit/debit card details in the Secure Payment box and click Pay and Download XML Table. The XML table, ready for submission, will download to your computer in a couple of seconds. 6. Log in to the SEC filing website, fill in the 13F cover sheet, attach the 13F table and submit your filing. Done! Questions or need additional help? Email us, or call 585-385-3810. ___________________________ 1 Security and Type columns are not required since the service gets these values from the SEC 13F list. If there, these columns are ignored unless the Use entries ‘as is’ checkbox is checked in the submission form. 2 As per SEC guidelines, FIGI is optional.. 3 The Ticker column is not required. If you have this column, the symbols are included in the proof for your reference. 4 If there is no ShPrn column. the Default Shares/Principal value from the submission form is used for the entire table. If you have this column but some cells in it are blank, the default value is used for those cells. 5 Your table should either have the InvDiscretion column (which specifies sole/defined/other discretion for all shares in a line item), or ISole, IDefined and IOther columns which specify the number of shares in each category. If none of these four columns exist, then the Default Investment Discretion value from the submission form applies to all shares in the entire table. If the InvDiscretion column exists but some cells in it are blank, the default value is used for those cells. If your table has ISole, IDefined and IOther columns, the service breaks out the shares into multiple rows to satisfy the SEC Information Table layout. 6 Index numbers in the OtherManagers column refer to correspondng numbers in the 13F cover sheet. If your table does not have this column, the Default Other Managers value from the submission form is used for the entire table. If you have this column but some cells in it are blank, the default value is used for those cells. The value may be blank if there are no other managers. 7 Your table should either have the VotingAuthority column (which specifies sole/shared/none authority for all shares in a line item), or VSole, VShared and VNone columns which specify the number of shares in each category. If none of these four columns exist, then the Default Voting Authority value from the submission form applies to all shares in the entire table. If the VotingAuthority column exists but some cells in it are blank, the default value is used for those cells. If your table does not have VSole, VShared and VNone columns, the service automatically creates them to satisfy the SEC Information Table layout. 8 Some CUSIPs look like floating point numbers to Excel, and it may reformat them when saving to a CSV file, which renders them invalid. Changing cell formats to text prevents this.
a
SEC Form 13F - Self-file Portal
13f.acii.com
a division of Advanced Computer Innovations, Inc.
70 Office Park Way • Pittsford, NY 14534-1746 (USA)
Phone: (585)-385-3810 • Email: click here
How it works
This portal lets you easily create the 13F XML Information Table from your Excel or other spreadsheets, with EDGAR validation guaranteed. Just follow these simple steps: 1. No need to redo your holdings table spreadsheet(s). You only need the relevant columns to have the following heading labels (shown bold): • CUSIP - uniquely identifies each security • Quantity - shares, or principal amount • Value - market value (in dollars) • Security - name of the security 1 • Type - type of security 1 • FIGI - financial instrument global identifier 2 • Ticker - ticker symbol 3 • ShPrn - shares (SH) or principal (PRN) 4 • PutCall - required only for options • InvDiscretion - sole/defined/other 5 • ISole - sole investment discretion (shares) 5 • IDefined - defined investment discretion (shares) 5 • IOther - other investment discretion (shares) 5 • OtherManagers - index numbers 6 • VotingAuthority - sole/shared/none 7 • VSole - sole voting authority (shares) 7 • VShared - shared voting authority (shares) 7 • VNone - no voting authority (shares) 7 Columns may be in any order. CUSIP, Quantity and Value are the only required columns. The other columns may be omitted if default values are appropriate. Extra columns having other labels are ignored. Click here to download a sample Excel file. 2. Remove extra rows from the table, leaving column headings in the first row followed by security entries and nothing else. Change all cell formats to text 8 and save as a comma- separated (.csv) file. 3. If you have multiple tables, do the above for each of them, then combine all the .csv files into a .zip file. 4. In the SEC Form 13F Self-Service box, fill in or edit any fields as needed and click Show Free Preview and Cost. The scrubbed and aggregated information table will display in a couple of seconds, along with the exact cost to produce the XML file. 5. Examine and check the information table. Once satisfied with the results, fill in your credit/debit card details in the Secure Payment box and click Pay and Download XML Table. The XML table, ready for submission, will download to your computer in a couple of seconds. 6. Log in to the SEC filing website, fill in the 13F cover sheet, attach the 13F table and submit your filing. Done! Questions or need additional help? Email us, or call 585-385-3810. ___________________________ 1 Security and Type columns are not required since the service gets these values from the SEC 13F list. If there, these columns are ignored unless the Use entries ‘as is’ checkbox is checked in the submission form. 2 As per SEC guidelines, FIGI is optional.. 3 The Ticker column is not required. If you have this column, the symbols are included in the proof for your reference. 4 If there is no ShPrn column. the Default Shares/Principal value from the submission form is used for the entire table. If you have this column but some cells in it are blank, the default value is used for those cells. 5 Your table should either have the InvDiscretion column (which specifies sole/defined/other discretion for all shares in a line item), or ISole, IDefined and IOther columns which specify the number of shares in each category. If none of these four columns exist, then the Default Investment Discretion value from the submission form applies to all shares in the entire table. If the InvDiscretion column exists but some cells in it are blank, the default value is used for those cells. If your table has ISole, IDefined and IOther columns, the service breaks out the shares into multiple rows to satisfy the SEC Information Table layout. 6 Index numbers in the OtherManagers column refer to correspondng numbers in the 13F cover sheet. If your table does not have this column, the Default Other Managers value from the submission form is used for the entire table. If you have this column but some cells in it are blank, the default value is used for those cells. The value may be blank if there are no other managers. 7 Your table should either have the VotingAuthority column (which specifies sole/shared/none authority for all shares in a line item), or VSole, VShared and VNone columns which specify the number of shares in each category. If none of these four columns exist, then the Default Voting Authority value from the submission form applies to all shares in the entire table. If the VotingAuthority column exists but some cells in it are blank, the default value is used for those cells. If your table does not have VSole, VShared and VNone columns, the service automatically creates them to satisfy the SEC Information Table layout. 8 Some CUSIPs look like floating point numbers to Excel, and it may reformat them when saving to a CSV file, which renders them invalid. Changing cell formats to text prevents this.
Copyright © Advanced Computer Innovations, Inc., 2023
Last updated 2023-02-07
a
