Budget Journal Spreadsheet Upload - Uploading Budget Spreadsheet Journals

Sep 12, 2026

Upload by Graffin

A step-by-step procedure describes how to upload large-volume budget journals efficiently using Cardinal’s budget journal spreadsheet upload workflow. Users prepare an Excel workbook with required journal information, then run an Excel macro that exports journal data into a .txt file for Cardinal ingestion. The guide covers downloading and configuring the macro/template files, enabling macros and editing security settings, defining options and defaults, creating journal sheets and headers, entering journal header and line fields (including NEXT behavior and ChartField/amount rules), and managing import status, notes, and journal editing actions.

LanguageEnglish

CategoryForms

FormatPDF

Pages15

Reading Time5 min

AccessFree to download

To Create and Upload a Budget Spreadsheet Journal

Download and prepare the required template and macro

Enable macros and access the upload home page

Set general options and use notes

Create journal sheets and journal headers

Enter journal lines, ChartField values, amounts, and optional Ref/Description

Simulation: Uploading a Budget Spreadsheet Journal

Uploading Budget Spreadsheet Journals Overview When entering budget journals with many lines, using the budget journal spreadsheet upload functionality in Cardinal can simplify the process for entering the data and save time. To upload a budget journal spreadsheet, you first enter the journal information in an Excel spreadsheet. The user initiates the Excel macro to write the budget journal data to a .txt file that is then uploaded into Cardinal. Table of Contents To Create and Upload a Budget Spreadsheet Journal ............................................................................. 1 Simulation: Uploading a Budget Spreadsheet Journal ....................................................................... 15 To Create and Upload a Budget Spreadsheet Journal 1. Download the two required files, entitled Budget Journal Spreadsheet Upload Excel Template and Budget Journal Spreadsheet Upload XLA Macro File , located on the Cardinal website in Forms under Resources. These two files must be saved to the same folder on your workstation. When downloading the Budget Journal Spreadsheet Upload XLA Macro File , change the filename to BudMcro3 and the extension from .xls to .xla. When complete, the file name should read BudMcro3 .xla Note: You can create multiple journal workbooks by saving a clean V_BUDJRNL4.xls file as V_BUDJRNL5.xls , etc. However, the macro sheet file name and extension, BudMcro3.xla , must not be changed or renamed. 2. Open, then minimize, the macro file. Open the V_BUDJRNL4.xls file. Upon opening this file, a security banner will display. 3. Click the Options button at the top of the screen beside the Security Warning message.‒ Select Enable Contents or Enable Editing (depending on the Excel version) . 4. If a pop-up box displays, select Enable this content and click the OK button. 5. If a second box displays, click the Enable Macros button. 6. The Budget Journal Spread Sheet Upload home page (main menu) displays. 7. Under the General section on the page, click the Setup button to access the Define Options and Defaults dialog box. Options set here will automatically populate budget journal sheets and budget journals created within this workbook. Enter the following values: ‒ Business Unit ‒ Date: Enter the appropriate date for each journal header individually. It is critical to enter a budget journal date that coincides with the budget period entered on the budget journal line. ‒ Ledger Group: Enter the value (e.g. , CC_APPROP) in CAPITAL letters. The second button under General on the Budget Journal Spread Sheet Upload home page is the Notes button. This button can be used to access another worksheet in the workbook that can be used as a scratch pad for instructions, calculations, and comments. After completing the fields, click the OK button. A workbook can contain as many journal sheets as needed. Each sheet will be a separate journal. There are four buttons under the Journal Sheets: ‒ New: inserts a new journal sheet ‒ Edit: edits an existing journal worksheet ‒ Delete: deletes one or more journal sheets in the workbook ‒ Copy: copies one journal sheet to a new journal sheet saved under a new name 8. Click the New button to insert a new Journal Sheet. 9. In the dialog box, enter a New Budget Journal Sheet Name and click the OK button. The Journal Sheet Name does not correspond to, nor will it transfer to, anything within Cardinal during the upload. 10. The Budget Journal Upload spreadsheet displays with the New Budget Journal Header window. Under the Journal Header there are six buttons: ‒ (+) (plus sign): adds a new budget journal header. ‒ Select Journal (white arrow): opens an existing budget journal. ‒ Edit Journal Header (red pencil): makes changes to the budget journal header. ‒ Copy Journal (two sheets of paper): copies a budget journal header and lines. ‒ Delete Journal (dash): deletes a budget journal entry. ‒ Change Import St

FAQs

What files are needed to upload a budget spreadsheet journal in Cardinal?

Download the Budget Journal Spreadsheet Upload Excel Template and the Budget Journal Spreadsheet Upload XLA Macro File from the Cardinal website. Save both to the same folder, and rename the macro file to BudMcro3 with the .xla extension.

Why is it important to enter the correct budget journal date?

The budget journal date must coincide with the budget period entered on each budget journal line. Entering a mismatched date is critical because Cardinal ties journals to the correct period.

How does the macro handle Journal ID and Line numbering?

When adding journal lines, the macro populates the Journal ID cell with NEXT and automatically increments the Line number as new lines are added.

Sep 12, 2026

Upload by Graffin