Difference between revisions of "Actuals - Cash"

From BudgetLink Wiki
Jump to navigation Jump to search
Line 1: Line 1:
== Overview ==
== Overview ==


BudgetLink allows you to report actual data on a Cash Accounting Method in addition to Accrual Accounting Method. 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 on a Cash Accounting Method in addition to an Accrual Accounting Method. BudgetLink supports two types of Cash Versions. The Cash version 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.
 
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.
The Cash versions are currently only available to MYOB AccountRight V19.9 or below.


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.
By default when BudgetLink is installed both Cash Editions are disabled because they the slow the get data process when enabled.


== Enable Cash Version ==
== Enable a Cash Version ==


# To enable a Cash version, start BudgetLink and go to 30. Settings > Options and Administration > Set User Options
# To enable a Cash version, start BudgetLink and go to 30. Settings > Options and Administration > Set User Options
Line 18: Line 20:




== Using the Cash Version ==
== 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
Before the Cash data will appear in the reports the data needs to be retrieved from MYOB and calculated. To do this
Line 26: Line 28:
Upon completion the cash data will be loaded into memory ready for reporting
Upon completion the cash data will be loaded into memory ready for reporting


Upon customising a report, depending on the report the following changes will appear in the Customise Dialogue :
 
== Report on a Cash Basis ==
 
Upon customising a report, depending on the report the following additional filters will appear in the Customise Dialogue:
# For some reports an Actual Version filter with options of Actual (Accrual) or Cash (MYOB Cash)/Cash DR CR will display
# For some reports an Actual Version filter with options of Actual (Accrual) or Cash (MYOB Cash)/Cash DR CR will display
# For others either the Cash or Cash DR CR version will appear in the existing Version drop down
# For others either the Cash or Cash DR CR version will display in the existing Version drop down

Revision as of 20:17, 4 December 2013

Overview

BudgetLink allows you to report actual data on a Cash Accounting Method in addition to an Accrual Accounting Method. BudgetLink supports two types of Cash Versions. The Cash version 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.

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.

Enable a Cash Version

  1. To enable a Cash version, start BudgetLink and go to 30. Settings > Options and Administration > Set User Options
  2. In the options list click Versions
  3. To enable a Cash Version, either untick 'Disable Cash Version' to enable the MYOB 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