SEC Form 13-F - Cost-efficient Web-based Self-Service
Investment Managers with $100 million or more in assets under management must file SEC Form 13-F to disclose qualifying holdings every quarter. This filing has 2 parts: 1. Cover sheet, which can be completed as an online form at the SEC filing website. 2. Information table detailing the qualifying securities in XML format. Companies must convert data from their spreadsheets into this format. Our easy-to-use web-based service scrubs, filters, aggregates and organizes the securities in your raw spreadsheets, and creates the submission-ready XML table very cost-effectively with many benefits: • No software to purchase, install and maintain • No significant changes needed to your spreadsheets - you don’t need to lay them out in any particular format • No need to aggregate, scrub or filter holdings against the SEC 13-F list - this service does it all for you • No learning needed - this single page has all the instructions • View the processed results at no charge - pay only to download the final XML file • Very cost-effective - most filings are $100 to $125. • All data and transactions secured with TLS encryptionHow it works
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 - number of 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 (number of shares) 5 • IDefined - defined investment discretion (number of shares) 5 • IOther - other investment discretion (number of shares) 5 • OtherManagers or Managers - comma-separated index numbers 6 • VotingAuthority or Authority - sole/shared/none 7 • VSole - sole voting authority (number of shares) 7 • VShared - shared voting authority (number of shares) 7 • VNone - no voting authority (number of 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 13-F 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 13-F cover sheet, attach the 13-F table and submit your filing. Done! Questions or need additional help? Email us, or call/text 585-310-1740 8am to 6pm EST. _________________________ 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: 1. If any sheets do not contain 13-F data, change those sheet names to start with ! (e.g., !Sheet5). 2. 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.About us
When you use a service, you want to know it’s reputable, reliable and there for you. So here’s some background: Advanced Computer Innovations, Inc. has been developing EDGAR filing solutions since the earliest days of EDGAR (1993). Our current offerings range from traditionally licensed desktop and networked- office software to pay-as-you-go cloud/web-based AaaS (application as a service). For EDGAR filings, these include: • EDGARsuite ™ - Premier SEC EDGAR Filing Software, a professional heavy-duty filing solution including iXBRL, HTML and XML format filings with automated single-click submission to EDGAR. • InstantEDGAR ™ - a Microsoft Word Add-in for easily creating EDGAR-valid HTML from Word documents for less frequent users desiring a locally installed pay-as-you-go solution. • web.acii.com/edgar.htm - a cloud/web-based AaaS (application as a service) for converting Microsoft Word documents to EDGAR-valid HTML - the most economical option, with nothing to install or maintain locally. • web.acii.com/pdf-to-edgar.htm - a cloud/web-based AaaS (application as a service) for converting PDF files to EDGAR-valid HTML - the most economical option, with nothing to install or maintain locally. • web.acii.com/8k.htm - a cloud/web-based AaaS (application as a service) to prepare an 8-K filing (including cover page XBRL) from a Word document containing the body of the 8-K, using simple form-fill for the cover page - the most economical option, with nothing to install or maintain locally. • web.acii.com/npx.htm - a cloud/web-based AaaS (application as a service) for preparing the XML Information Table in N-PX (Proxy Voting Record) filings, with nothing to install or maintain locally. • web.acii.com/late.htm - a cloud/web-based Aaas (application as a service) for preparing and submitting an SEC form 12b-25 notification of late filing by filling in a simple form. • web.acii.com/ownership.htm - a cloud/web-based Aaas (application as a service) for preparing and submitting SEC Beneficial Ownership Filings (forms 13G, 13D, 3, 4 and 5), all by filling in a simple form. And above all, we’re there for you. If you have any questions or issues, we’re only a phone call/text (585-310-1740) or email away!
585-310-1740 | Email: click here
c/o Advanced Computer Innovations, Inc.
70 Office Park Way • Pittsford, NY 14534-1746
web.acii.com
Web-based Services
Copyright © Advanced Computer Innovations, Inc., 2024 - Last updated 2024-10-15
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 13-F - Cost-efficient Web-based
Self-Service
Investment Managers with $100 million or more in assets under management must file SEC Form 13-F to disclose qualifying holdings every quarter. This filing has 2 parts: 1. Cover sheet, which can be completed as an online form at the SEC filing website. 2. Information table detailing the qualifying securities in XML format. Companies must convert data from their spreadsheets into this format. Our easy-to-use web-based service scrubs, filters, aggregates and organizes the securities in your raw spreadsheets, and creates the submission-ready XML table very cost-effectively with many benefits: • No software to purchase, install and maintain • No significant changes needed to your spreadsheets - you don’t need to lay them out in any particular format • No need to aggregate, scrub or filter holdings against the SEC 13-F list - this service does it all for you • No learning needed - this single page has all the instructions • View the processed results at no charge - pay only to download the final XML file • Very cost-effective - most filings are $100 to $125. • All data and transactions secured with TLS encryptionHow it works
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 - number of 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 (number of shares) 5 • IDefined - defined investment discretion (number of shares) 5 • IOther - other investment discretion (number of shares) 5 • OtherManagers or Managers - comma- separated index numbers 6 • VotingAuthority or Authority - sole/shared/none 7 • VSole - sole voting authority (number of shares) 7 • VShared - shared voting authority (number of shares) 7 • VNone - no voting authority (number of 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 13-F 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 13-F cover sheet, attach the 13-F table and submit your filing. Done! Questions or need additional help? Email us, or call/text 585-310-1740 8am to 6pm EST. _________________________ 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: 1. If any sheets do not contain 13-F data, change those sheet names to start with ! (e.g., !Sheet5). 2. 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.About us
When you use a service, you want to know it’s reputable, reliable and there for you. So here’s some background: Advanced Computer Innovations, Inc. has been developing EDGAR filing solutions since the earliest days of EDGAR (1993). Our current offerings range from traditionally licensed desktop and networked-office software to pay-as-you-go cloud/web-based AaaS (application as a service). For EDGAR filings, these include: • EDGARsuite ™ - Premier SEC EDGAR Filing Software, a professional heavy-duty filing solution including iXBRL, HTML and XML format filings with automated single-click submission to EDGAR. • InstantEDGAR ™ - a Microsoft Word Add-in for easily creating EDGAR-valid HTML from Word documents for less frequent users desiring a locally installed pay-as-you-go solution. • web.acii.com/edgar.htm - a cloud/web-based AaaS (application as a service) for converting Microsoft Word documents to EDGAR-valid HTML - the most economical option, with nothing to install or maintain locally. • web.acii.com/pdf-to-edgar.htm - a cloud/web-based AaaS (application as a service) for converting PDF files to EDGAR-valid HTML - the most economical option, with nothing to install or maintain locally. • web.acii.com/8k.htm - a cloud/web-based AaaS (application as a service) to prepare an 8-K filing (including cover page XBRL) from a Word document containing the body of the 8-K, using simple form-fill for the cover page - the most economical option, with nothing to install or maintain locally. • web.acii.com/npx.htm - a cloud/web-based AaaS (application as a service) for preparing the XML Information Table in N-PX (Proxy Voting Record) filings, with nothing to install or maintain locally. • web.acii.com/late.htm - a cloud/web-based Aaas (application as a service) for preparing and submitting an SEC form 12b-25 notification of late filing by filling in a simple form. • web.acii.com/ownership.htm - a cloud/web-based Aaas (application as a service) for preparing and submitting SEC Beneficial Ownership Filings (forms 13G, 13D, 3, 4 and 5), all by filling in a simple form. And above all, we’re there for you. If you have any questions or issues, we’re only a phone call/text (585-310-1740) or email away!
585-310-1740 | Email: click here
c/o Advanced Computer Innovations, Inc.
70 Office Park Way • Pittsford, NY 14534-1746
web.acii.com
Web-based Services
Copyright © Advanced Computer Innovations, Inc., 2024 - Last updated 2024-10-15
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
web.acii.com
585-310-1740 | Email: click here
c/o Advanced Computer Innovations, Inc.
70 Office Park Way • Pittsford, NY 14534-1746
SEC Form 13-F - Cost-efficient
Web-based Self-Service
Investment Managers with $100 million or more in assets under management must file SEC Form 13-F to disclose qualifying holdings every quarter. This filing has 2 parts: 1. Cover sheet, which can be completed as an online form at the SEC filing website. 2. Information table detailing the qualifying securities in XML format. Companies must convert data from their spreadsheets into this format. Our easy-to-use web-based service scrubs, filters, aggregates and organizes the securities in your raw spreadsheets, and creates the submission-ready XML table very cost-effectively with many benefits: • No software to purchase, install and maintain • No significant changes needed to your spreadsheets - you don’t need to lay them out in any particular format • No need to aggregate, scrub or filter holdings against the SEC 13-F list - this service does it all for you • No learning needed - this single page has all the instructions • View the processed results at no charge - pay only to download the final XML file • Very cost-effective - most filings are $100 to $125. • All data and transactions secured with TLS encryptionHow it works
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 - number of 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 (number of shares) 5 • IDefined - defined investment discretion (number of shares) 5 • IOther - other investment discretion (number of shares) 5 • OtherManagers or Managers - comma-separated index numbers 6 • VotingAuthority or Authority - sole/shared/none 7 • VSole - sole voting authority (number of shares) 7 • VShared - shared voting authority (number of shares) 7 • VNone - no voting authority (number of 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 13-F 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 13-F cover sheet, attach the 13-F table and submit your filing. Done! Questions or need additional help? Email us, or call/text 585-310-1740 8am to 6pm EST. _________________________ 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: 1. If any sheets do not contain 13-F data, change those sheet names to start with ! (e.g., !Sheet5). 2. 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.About us
When you use a service, you want to know it’s reputable, reliable and there for you. So here’s some background: Advanced Computer Innovations, Inc. has been developing EDGAR filing solutions since the earliest days of EDGAR (1993). Our current offerings range from traditionally licensed desktop and networked-office software to pay-as-you-go cloud/web-based AaaS (application as a service). For EDGAR filings, these include: • EDGARsuite ™ - Premier SEC EDGAR Filing Software, a professional heavy-duty filing solution including iXBRL, HTML and XML format filings with automated single-click submission to EDGAR. • InstantEDGAR ™ - a Microsoft Word Add-in for easily creating EDGAR-valid HTML from Word documents for less frequent users desiring a locally installed pay-as-you-go solution. • web.acii.com/edgar.htm - a cloud/web-based AaaS (application as a service) for converting Microsoft Word documents to EDGAR-valid HTML - the most economical option, with nothing to install or maintain locally. • web.acii.com/pdf-to-edgar.htm - a cloud/web-based AaaS (application as a service) for converting PDF files to EDGAR-valid HTML - the most economical option, with nothing to install or maintain locally. • web.acii.com/8k.htm - a cloud/web-based AaaS (application as a service) to prepare an 8-K filing (including cover page XBRL) from a Word document containing the body of the 8-K, using simple form-fill for the cover page - the most economical option, with nothing to install or maintain locally. • web.acii.com/npx.htm - a cloud/web-based AaaS (application as a service) for preparing the XML Information Table in N-PX (Proxy Voting Record) filings, with nothing to install or maintain locally. • web.acii.com/late.htm - a cloud/web-based Aaas (application as a service) for preparing and submitting an SEC form 12b-25 notification of late filing by filling in a simple form. • web.acii.com/ownership.htm - a cloud/web-based Aaas (application as a service) for preparing and submitting SEC Beneficial Ownership Filings (forms 13G, 13D, 3, 4 and 5), all by filling in a simple form. And above all, we’re there for you. If you have any questions or issues, we’re only a phone call/text (585-310-1740) or email away!
Web-based Services
Copyright © Advanced Computer Innovations, Inc., 2024 - Last updated 2024-10-15
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
web.acii.com
585-310-1740 | Email: click here
c/o Advanced Computer Innovations, Inc.
70 Office Park Way • Pittsford, NY 14534-1746
SEC Form 13-F -
Cost-efficient
Web-based Self-Service
Investment Managers with $100 million or more in assets under management must file SEC Form 13-F to disclose qualifying holdings every quarter. This filing has 2 parts: 1. Cover sheet, which can be completed as an online form at the SEC filing website. 2. Information table detailing the qualifying securities in XML format. Companies must convert data from their spreadsheets into this format. Our easy-to-use web-based service scrubs, filters, aggregates and organizes the securities in your raw spreadsheets, and creates the submission-ready XML table very cost-effectively with many benefits: • No software to purchase, install and maintain • No significant changes needed to your spreadsheets - you don’t need to lay them out in any particular format • No need to aggregate, scrub or filter holdings against the SEC 13-F list - this service does it all for you • No learning needed - this single page has all the instructions • View the processed results at no charge - pay only to download the final XML file • Very cost-effective - most filings are $100 to $125. • All data and transactions secured with TLS encryptionHow it works
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 - number of 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 (number of shares) 5 • IDefined - defined investment discretion (number of shares) 5 • IOther - other investment discretion (number of shares) 5 • OtherManagers or Managers - comma- separated index numbers 6 • VotingAuthority or Authority - sole/shared/none 7 • VSole - sole voting authority (number of shares) 7 • VShared - shared voting authority (number of shares) 7 • VNone - no voting authority (number of 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 13-F 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 13- F cover sheet, attach the 13-F table and submit your filing. Done! Questions or need additional help? Email us, or call/text 585-310-1740 8am to 6pm EST. _________________________ 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: 1. If any sheets do not contain 13-F data, change those sheet names to start with ! (e.g., !Sheet5). 2. 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.About us
When you use a service, you want to know it’s reputable, reliable and there for you. So here’s some background: Advanced Computer Innovations, Inc. has been developing EDGAR filing solutions since the earliest days of EDGAR (1993). Our current offerings range from traditionally licensed desktop and networked-office software to pay-as-you-go cloud/web-based AaaS (application as a service). For EDGAR filings, these include: • EDGARsuite ™ - Premier SEC EDGAR Filing Software, a professional heavy-duty filing solution including iXBRL, HTML and XML format filings with automated single-click submission to EDGAR. • InstantEDGAR ™ - a Microsoft Word Add-in for easily creating EDGAR-valid HTML from Word documents for less frequent users desiring a locally installed pay-as-you-go solution. • web.acii.com/edgar.htm - a cloud/web-based AaaS (application as a service) for converting Microsoft Word documents to EDGAR-valid HTML - the most economical option, with nothing to install or maintain locally. • web.acii.com/pdf-to-edgar.htm - a cloud/web- based AaaS (application as a service) for converting PDF files to EDGAR-valid HTML - the most economical option, with nothing to install or maintain locally. • web.acii.com/8k.htm - a cloud/web-based AaaS (application as a service) to prepare an 8-K filing (including cover page XBRL) from a Word document containing the body of the 8-K, using simple form-fill for the cover page - the most economical option, with nothing to install or maintain locally. • web.acii.com/npx.htm - a cloud/web-based AaaS (application as a service) for preparing the XML Information Table in N-PX (Proxy Voting Record) filings, with nothing to install or maintain locally. • web.acii.com/late.htm - a cloud/web-based Aaas (application as a service) for preparing and submitting an SEC form 12b-25 notification of late filing by filling in a simple form. • web.acii.com/ownership.htm - a cloud/web- based Aaas (application as a service) for preparing and submitting SEC Beneficial Ownership Filings (forms 13G, 13D, 3, 4 and 5), all by filling in a simple form. And above all, we’re there for you. If you have any questions or issues, we’re only a phone call/text (585-310-1740) or email away!
Web-based Services
Copyright © Advanced Computer Innovations, Inc., 2024
Last updated 2024-10-15
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
