Budget journal account sets import
Budget entries can be entered and imported from Excel. Amounts can be associated with account sets and general ledger accounts.
Budget journal account sets import template file
To download the budget journal account sets import template file, select the following link:
Import Budget Journal from Excel Account Sets Template
Document No.
When a user imports budget journal account sets information into Sparkrock 365, the Document No. is taken from the specified template. When the value for the Document No. column in the template is blank, the import uses the applicable number series from the budget journal batch. Otherwise, when the value in the template is blank and there is no number series, an error is displayed.
If there are lines in the import file where the Document No. field is blank, and other lines have values in the Document No. field, the Document No. field on the Budget Journal page is populated based on the numbering convention within the document, not from the number series. If a user imports a budget journal using the document numbers from the import file, and does not post the budget journal before importing another document that does not include document numbers, the Document No. field on the Budget Journal page is populated with the numbering convention from the previous import.
Feedback
To send feedback about this page, select the following link: