Why Import Forecasts from Online Excel?
By importing forecasts from online Excel files, you can:
Maintain real-time synchronization between your Excel forecasts and Agicap.
Eliminate manual data entry, reducing the risk of errors.
Simplify collaboration with your team by using shared online Excel sheets.
Step-by-Step Guide to Import Forecasts
Follow these steps to import your forecasts from an online Excel file into Agicap:
1. Access the Import Feature
Log in to your Agicap account.
Navigate to the Cashflow section.
Click on Options and then on Import forecast.
2. Prepare your Excel Online
Ensure your forecast data is organized in a way that Agicap can interpret. Typically, this means having dates in one column and the corresponding financial figures in another. You can download a template by following step 2.
3. Connect Your Excel File
Enter the URL of your online Excel file (e.g., OneDrive, SharePoint).
Authenticate your account if prompted.
4. Review and Confirm
Preview the imported data to ensure everything is correct.
Click Import to complete the process.
Managing Imported Forecasts
View Imported Data: Imported forecasts will appear in your cashflow projections.
Automatic Updates: Any changes made in the online Excel file can be automatically synced by enabling the Auto-Update feature.
Edit Forecasts: You can manually adjust forecasts in Agicap if needed.
Benefits of Using Online Excel Integration
Real-Time Updates: Keep your forecasts current without manual imports.
Collaboration: Work with your team on the same Excel file, and see changes reflected in Agicap.
Flexibility: Use familiar Excel tools while leveraging Agicap's powerful cashflow management features.
💡 Tips
Automate Syncing: Enable Auto-Update to ensure Agicap always has the latest data from your Excel file.
Use Templates: Standardize your Excel forecast format for smoother imports.
Backup Data: Regularly save copies of your Excel files for data security.
Q&A ❓
How often does Agicap sync with my online Excel file?
Agicap can sync with your online Excel file automatically every hour if you enable the Auto-Update feature during the import process.
Can I import forecasts from multiple Excel files?
Yes, you can import forecasts from multiple online Excel files by repeating the import process for each file. Ensure that each file is properly mapped during import.
What if my Excel file requires authentication?
During the connection step, Agicap will prompt you to authenticate your account to access the Excel file securely.
Can I edit imported forecasts directly in Agicap?
Absolutely! Imported forecasts can be edited within Agicap. Changes made in Agicap will not affect the original Excel file unless you re-import or sync the data.
Is my data secure during the import process?
Yes, Agicap uses secure connections and complies with data protection regulations to ensure your information is safe during import and synchronization.