Difference between revisions of "Actuals - Cash"

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


BudgetLink allows you to report actuals on a Cash Basis as opposed to an Accrual basis. BudgetLink supports two types of Cash Versions. One is MYOB Cash which matches the Cash Profit and Loss Report generated in MYOB. The second is Cash CR DR which only displays cash transactions that appear in the Cash Receipts and Cash Disbursement journals.  
BudgetLink allows you to report actual data using a Cash Accounting Method in addition to the Accrual Accounting Method. BudgetLink supports two types of Cash Versions. The Cash version matches the Cash Profit and Loss Report generated in MYOB. The 'Cash CR DR' version only displays cash transactions that appear in the Cash Receipts and Cash Disbursement journals.  


The Cash versions are only available to MYOB AccountRight V19.9 or below.
In addition to displaying profit and loss data on a cash basis, it is also possible to produce a balance sheet and cash flow statement on a cash basis.


By default when BudgetLink is installed the Cash Edition is not enabled. The reason is that it pulls data from most of the detail transaction tables which slows the get data process.
The Cash versions are currently only available to MYOB AccountRight V19.9 or below.


By default when BudgetLink is installed both Cash Editions are disabled because they the slow the get data process when enabled.


== Enable Cash Version ==
== Supported Accounting Software ==


# To enable a Cash version, start BudgetLink and from the Menu go to 30. Settings > Options and Administration > Set User Options
* [[MYOB AccountRight Classic]]
# Click Versions
 
# To enable a Cash Version, either untick 'Disable Cash Version' to enable the MYOB Cash version or untick 'Disable Cash DR CR Version'
== Enable a Cash Version ==
# In the BudgetLink Warning message click OK to confirm that you understand that this option will significantly slow the get data process down
 
# To enable a Cash version, start BudgetLink and go to 30. Settings > Options> Set User Options
# In the options list click Versions
# To enable a Cash Version, either untick 'Disable Cash Version' or untick 'Disable Cash DR CR Version'
# In the BudgetLink Warning message click OK to confirm that you understand that this option will slow the get data process down
# Click Save
# Click Save
# In the New - Options Saved form click OK
# In the Note - Options Saved form click OK to close the form
# In the Options dialogue, click Close
# In the Options dialogue, click Close
# Goto 30. Settings > Data Files
 
== Retrieve Cash Data ==
 
Before the Cash data will appear in the reports the data needs to be retrieved from MYOB and calculated. To do this
# Go to 30. Settings > Data Files
# Click Get Data
# Click Get Data
# Choose Full Get Data and Click OK
# Choose Full Get Data and Click OK
Upon completion the cash data will be loaded into memory ready for reporting


== Using the Cash Version ==
== Report on a Cash Basis ==


Once the Cash Version has been enabled, The Customise form on reports will be modified as follows depending on the report it was opened from:
Upon customising a report, depending on the report the following additional filters will appear in the Customise Dialogue:
# Some reports will either display an Actual Version filter witht options of Actual (Accrual) or Cash (MYOB Cash)/Cash DR CR
# For some reports an Actual Version filter with options of Actual (Accrual) or Cash (MYOB Cash)/Cash DR CR will display
# Others will include either the Cash or Cash DR CR version in the Version drop down
# For others either the Cash or Cash DR CR version will display in the existing Version drop down

Latest revision as of 19:50, 24 May 2017

Overview

BudgetLink allows you to report actual data using a Cash Accounting Method in addition to the Accrual Accounting Method. BudgetLink supports two types of Cash Versions. The Cash version matches the Cash Profit and Loss Report generated in MYOB. The 'Cash CR DR' version only displays cash transactions that appear in the Cash Receipts and Cash Disbursement journals.

In addition to displaying profit and loss data on a cash basis, it is also possible to produce a balance sheet and cash flow statement on a cash basis.

The Cash versions are currently only available to MYOB AccountRight V19.9 or below.

By default when BudgetLink is installed both Cash Editions are disabled because they the slow the get data process when enabled.

Supported Accounting Software

Enable a Cash Version

  1. To enable a Cash version, start BudgetLink and go to 30. Settings > Options> Set User Options
  2. In the options list click Versions
  3. To enable a Cash Version, either untick 'Disable Cash Version' or untick 'Disable Cash DR CR Version'
  4. In the BudgetLink Warning message click OK to confirm that you understand that this option will slow the get data process down
  5. Click Save
  6. In the Note - Options Saved form click OK to close the form
  7. In the Options dialogue, click Close

Retrieve Cash Data

Before the Cash data will appear in the reports the data needs to be retrieved from MYOB and calculated. To do this

  1. Go to 30. Settings > Data Files
  2. Click Get Data
  3. Choose Full Get Data and Click OK

Upon completion the cash data will be loaded into memory ready for reporting


Report on a Cash Basis

Upon customising a report, depending on the report the following additional filters will appear in the Customise Dialogue:

  1. For some reports an Actual Version filter with options of Actual (Accrual) or Cash (MYOB Cash)/Cash DR CR will display
  2. For others either the Cash or Cash DR CR version will display in the existing Version drop down