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 or Text: 585-310-1740 • 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 - case, spaces and punctuation are not significant): • CUSIP - uniquely identifies each security • Quantity or Amount - shares, or principal amount • Value or MarketValue - market value (in dollars) • Security or Name - name of the security 1 • Type or Class or Title - type of security 1 • FIGI - financial instrument global identifier 2 • Ticker or Symbol - ticker symbol 3 • ShPrn or PrnSh - shares (SH) or principal (PRN) 4 • PutCall or CallPut - required only for options • InvDiscretion or Discretion - sole/defined/other 5 • ISole - sole investment discretion (shares) 5 • IDefined - defined investment discretion (shares) 5 • IOther - other investment discretion (shares) 5 • OtherManagers or Managers - index numbers 6 • VotingAuthority or Authority - 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. 3. If you have tables in multiple files, do the above for each and combine 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/text 585-310- 1740. ___________________________ 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.Notes
You may upload Excel files saved as .xlsx, .xlsm or .csv. Older .xls format files must be saved as one of these types to use this service.Excel files with Multiple Sheets (Tabs)
• If 13-F data is in only one sheet (most common situation), make sure that sheet is showing and save the file. The platform will process only the visible sheet. • If 13-F data is in several sheets (e.g., different accounts in separate sheets), do the following: o If any sheets do not contain 13-F data, change those sheet names to start with ! (e.g., !Sheet5). o Change the Excel file name to end with ! (e.g., 13F-data!.xlsx). The platform will then process securites in all sheets named without !, and it does not matter which sheet is visible.
Copyright © Advanced Computer Innovations, Inc., 2024
Last updated 2024-10-07
EDGAR® and SEC® are trademarks of the U.S. Securities and Exchange Commission. Advanced Computer Innovations, Inc.’s products and services are not affiliated with or approved by the U.S. Securities and Exchange
Commission.
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 or Text: 585-310-1740 • Email: click here
Copyright © Advanced Computer Innovations, Inc., 2024
Last updated 2024-10-07
EDGAR® and SEC® are trademarks of the U.S. Securities and Exchange Commission. Advanced Computer Innovations, Inc.’s products and services are not
affiliated with or approved by the U.S. Securities and Exchange Commission.
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 - case, spaces and punctuation are not significant): • CUSIP - uniquely identifies each security • Quantity or Amount - shares, or principal amount • Value or MarketValue - market value (in dollars) • Security or Name - name of the security 1 • Type or Class or Title - type of security 1 • FIGI - financial instrument global identifier 2 • Ticker or Symbol - ticker symbol 3 • ShPrn or PrnSh - shares (SH) or principal (PRN) 4 • PutCall or CallPut - required only for options • InvDiscretion or Discretion - sole/defined/other 5 • ISole - sole investment discretion (shares) 5 • IDefined - defined investment discretion (shares) 5 • IOther - other investment discretion (shares) 5 • OtherManagers or Managers - index numbers 6 • VotingAuthority or Authority - 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. 3. If you have tables in multiple files, do the above for each and combine 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/text 585-310-1740. ___________________________ 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.Notes
You may upload Excel files saved as .xlsx, .xlsm or .csv. Older .xls format files must be saved as one of these types to use this service.Excel files with Multiple Sheets (Tabs)
• If 13-F data is in only one sheet (most common situation), make sure that sheet is showing and save the file. The platform will process only the visible sheet. • If 13-F data is in several sheets (e.g., different accounts in separate sheets), do the following: o If any sheets do not contain 13-F data, change those sheet names to start with ! (e.g., !Sheet5). o Change the Excel file name to end with ! (e.g., 13F-data!.xlsx). The platform will then process securites in all sheets named without !, and it does not matter which sheet is visible.
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 or Text: 585-310-1740 • 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 - case, spaces and punctuation are not significant): • CUSIP - uniquely identifies each security • Quantity or Amount - shares, or principal amount • Value or MarketValue - market value (in dollars) • Security or Name - name of the security 1 • Type or Class or Title - type of security 1 • FIGI - financial instrument global identifier 2 • Ticker or Symbol - ticker symbol 3 • ShPrn or PrnSh - shares (SH) or principal (PRN) 4 • PutCall or CallPut - required only for options • InvDiscretion or Discretion - sole/defined/other 5 • ISole - sole investment discretion (shares) 5 • IDefined - defined investment discretion (shares) 5 • IOther - other investment discretion (shares) 5 • OtherManagers or Managers - index numbers 6 • VotingAuthority or Authority - 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. 3. If you have tables in multiple files, do the above for each and combine 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/text 585-310-1740. ___________________________ 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.Notes
You may upload Excel files saved as .xlsx, .xlsm or .csv. Older .xls format files must be saved as one of these types to use this service.Excel files with Multiple Sheets (Tabs)
• If 13-F data is in only one sheet (most common situation), make sure that sheet is showing and save the file. The platform will process only the visible sheet. • If 13-F data is in several sheets (e.g., different accounts in separate sheets), do the following: o If any sheets do not contain 13-F data, change those sheet names to start with ! (e.g., !Sheet5). o Change the Excel file name to end with ! (e.g., 13F-data!.xlsx). The platform will then process securites in all sheets named without !, and it does not matter which sheet is visible.
Copyright © Advanced Computer Innovations, Inc., 2024
Last updated 2024-10-07
EDGAR® and SEC® are trademarks of the U.S. Securities and Exchange
Commission. Advanced Computer Innovations, Inc.’s products and services
are not affiliated with or approved by the U.S. Securities and Exchange
Commission.
a
