Difference between revisions of "Importing Budgets"

From BudgetLink Wiki
Jump to navigation Jump to search
 
(22 intermediate revisions by 2 users not shown)
Line 1: Line 1:
== Overview ==
== Overview ==


Budgets can be imported into BudgetLink in a few different ways.  
[[Budgets]] can be imported into BudgetLink in a few different ways.  


# Some budgets can be read directly from your accounting package;
# Some budgets can be read directly from your accounting package;
Line 7: Line 7:
# Budgets can be imported from templates created within BudgetLink.
# Budgets can be imported from templates created within BudgetLink.


=== Importing Budgets from a custom spread sheet ===
== Importing Budgets ==


If you have taken the time of creating your own spreadsheets to devise your Budgets, follow these instructions to import your budget. You will need to ensure that your spread sheet contains, at a minimum the [[Accounts|account numbers]] and [[Periods|periods]] the budget relates to.
There are two different ways to import budgets.


# From the '''Menu''', click on '''20. Budget Entry''';
1: Import from a [[Importing Budgets from a custom spreadsheet|budget worksheet]] you created
# Click on '''Utilities''' link in the menu;
# From the Utilities page, click on '''Import from Worksheet''';
# Click '''Yes''' to take a backup of your budgets, prior to importing;
# In the '''Action''' list and choose whether to '''Update''' the budget data in BudgetLink (if any) with the data to be imported, or whether to '''Add''' or '''Subtract''' the data to be imported;
# In the '''Data Type''' list and choose whether the data to be imported is '''Movement''' or '''Balance''' data;
# In the '''Workbook''' list and select the desired workbook. If it does not appear, you can use the '''Browse''' button to open your workbook;
# In the '''Worksheet''' list and select the desired worksheet;
# Select the '''Budget Version''' for which to import;
# Select the '''Company''' for which to import;
# Select the '''Financial Year''' for which to import;
# Click on the '''…''' button to the right of '''Accounts Range''' and highlight on your spreadsheet the accounts for which you wish to import data then click '''OK''';
# Click on the '''…''' button to the right of '''Months Range''' and highlight on your spreadsheet the months for which you wish to import data and click '''OK''';
# Select the '''Job''' for which to import. If you have multiple jobs in your spreadsheet, tick the '''Use Range''' checkbox instead. Then click on the '''…''' button to the right of '''Jobs Range''' and highlight on your spreadsheet the jobs for which you wish to import data then click '''OK''';
# Click '''OK''' on the Import Budget Data dialog box to import the data. Click '''OK''' when the import is complete.


After importing, it is recommended that you review the imported budget data. For further information, see [[Entering Budgets]].
2: Import from a [[From a Budget Template|budget template]] created from within BudgetLink
 
==== Notes ====
 
* If you have more than one row or column for the same account, BudgetLink will automatically add the values together when they are imported.
* If you have created an annual budget rather than a monthly budget, ensure that the data is under a column labelled Annual. When imported into BudgetLink, the annual amounts will automatically be split evenly across all months in the financial year.
 
=== Importing Budgets from a Marked-Up Workbook or template ===
 
If you have used the [[Creating Budget Templates|Create Budget Template]] functionality to work through your budget, follow these instructions to import your budget.


== Related Topics ==
== Related Topics ==


[[Creating Budget Templates]]
* [[Exporting Budget Data]]
 
* [[Creating Budget Templates]]
[[Entering Budgets]]
* [[Entering Budgets]]
* [[Modifying Budget Data]]

Latest revision as of 21:48, 7 March 2017

Overview

Budgets can be imported into BudgetLink in a few different ways.

  1. Some budgets can be read directly from your accounting package;
  2. Budgets can be imported from custom spread sheet;
  3. Budgets can be imported from templates created within BudgetLink.

Importing Budgets

There are two different ways to import budgets.

1: Import from a budget worksheet you created

2: Import from a budget template created from within BudgetLink

Related Topics

Retrieved from "https://accountingaddons.com.au/wiki/budgetlink/index.php?title=Importing_Budgets&oldid=3530"