Intacct Real Estate
Intacct Real Estate
Breadcrumbs

Budgeting

This guide explains how to export annual charges for specific properties from Sage Intacct Real Estate and upload them seamlessly as budgets into Sage Intacct. Following these steps will streamline your budgeting process, reduce errors, and save time.

Requirements

Subscription

Real Estate

Regional availability

Canada

United States

User type

Business user with admin privileges to give access

Permissions

Menu option for each feature to determine whether it appears on the Applications menu

Configuration

  1. Enable the Real Estate subscription in Intacct.

  2. Add the URL to the allowlist: https://app.sagerealestate.us/

  3. Set all security options for the URL to true.

Implementation

Requires:

  • Subscription in Intacct

  • Configuration and setup in Intacct


Step 1: Generate a Projected Revenue Report

  1. Purpose: This report provides a detailed month-over-month breakdown of lease charges across properties, helping you verify your revenue forecasts.

  2. Process: Select the properties and download the report, which includes monthly and yearly summaries for each lease and property.

  3. Export: Save the report for further analysis as needed.

Report sample

image-20240927-160034.png
image-20240927-160128.png

Step 2: Generate the Annual Budget Export

  1. Purpose: This export retrieves one year of data in a Sage Intacct-compatible template format.

  2. Setup: Select the "As of Date" to define the starting point for the one-year period.

  3. Format: The "Reporting Period Name" column in the template will be auto-filled to match Sage Intacct’s format (e.g., "Month Ended January 2024").

  4. Download: Export the file in Excel format.

Report Sample

image-20240927-160735.png

Step 3: Prepare the File for Import

  1. Open and Clean Up:

    • Open the Excel exported for the Annual Budget Export in the previous step.

    • Delete any extra rows to ensure the template headers start at the first row.

image-20240927-162658.png

  1. Populate Required Fields: to populate the Sage Intacct-specific fields, the date should correspond to your Intacct environment.

  • BUDGET_ID

image-20240927-163107.png

  • ACCT_NO

This refers to the General Ledger account number and can be acquired from multiple sources, for example:

image-20240927-163653.png

Also, you can create a Sage Intacct custom report for mapping the GL account number with the Item ID of RE app:

image-20240927-164147.png

Finally, this is how the populated Excel should look like:

image-20240927-164454.png

  1. Save as CSV:

    • Save the file as a CSV, then reopen it to verify all columns are correctly formatted.

    • Delete any unnecessary columns to prevent import errors, as seen in column adjustments.

  2. Verify CSV Integrity:

    • Open the CSV in a text editor to confirm the delimiter format (e.g., comma or semicolon).

image-20240927-164931.png

We see everything is correct except for column N that is blank. Column M corresponds to March and column O to April (for this AsOfDate), so we just need to delete the column N to avoid any import failures.

After that modification we resave it as .csv format.

Step 4: Create Reporting Periods in Sage Intacct

All reporting periods referenced in your template must already exist or be created in Sage Intacct to avoid import errors. To set up reporting periods, go to Reports > Reporting Periods in Sage Intacct.

image-20240927-165707.png

Step 5: Import the Budget File

  1. Navigate to Import Section:

    • Go to Budget > Budget Planning or Budget Repository in Sage Intacct.

image-20240927-170038.png

  1. Choose Value Delimiter:

    • Use a text editor to check the CSV delimiter format and select the correct delimiter option during import.

image-20240927-170352.png

There can be seen that a semicolon (' ; ') is the correct separator.

  1. Import and Confirmation:

    • Import the file, and a confirmation email will be sent to you indicating import success or errors.