Company Information

On this Page:
 Get Company Name
 Get Company Status
 Get Sync Age
 Get GL 1st Period
 Get Current Period
 Get Current Year
 Combine Options

The following functions compliments the Consolidated XL functions to hot link the status and settings of a connected Accounting company.

   The Wizard "Get GL Values Example Wizard" shows how to use the functions below. It's best to create a sheet using the wizard, to understand the use and possibilities.



Get Company Name

Get a Income Sattement or Balance sheet using excel form Xero or Quickbooks
Get Company Name and Status

Syntax: =CXL.GetCompanyName( CompCode )
Performance Rated:A

   For a tutorial on this function, click here

This will get the company name given the short CompCode. Useful when consolidating multiple company financial reports from Sage Accounting, Xero or QuickBooks Accounting Software.

Syntax: =CXL.GetCompanyNameCur( CompCode )
Performance Rated:A++

This will get the company name given the short CompCode and the Home Currency appended to end 'My Company (USD)'.

Syntax: =CXL.GetHomeCurrency( CompCode )
Performance Rated:A++

This will get the company HOME currency given the short CompCode.

Get Company status

Syntax: =CXL.GetCompanyStatus( CompCode, [Options] )
Performance Rated:A++

   For a tutorial on this function, click here

This will get number of hours since last sync of financial data with from QuickBooks, Xero or Sage Accounting Software and the Current Financial Period.

Get Sync Age

Syntax: =CXL.GetLastSyncHours( CompCode )
Performance Rated:A++

This will get number of hours since last sync of financial data with from QuickBooks, Xero or Sage Accounting Software.

Get GL 1st Period

Syntax: =CXL.Get1stGLPeriod( CompCode )
Performance Rated:A++

This will get 1st period of financial period 1-12 from QuickBooks, Xero or Sage Accounting Software for reporting.

Get Current Period

Syntax: =CXL.GetCurrentPeriod( CompCode, [Options] )
Performance Rated:A++

This will get Current financial Period 1-12, or 1-52 if Weeks, from QuickBooks, Xero or Sage Accounting Software for reporting.

Get Current Year and Period

Syntax: =CXL.GetCurrentYearPeriod( CompCode, [Options] )
Performance Rated:A++

This will get Current financial Year and Period from QuickBooks, Xero or Sage Accounting Software for reporting.

Get Current Year

Syntax: =CXL.GetCurrentYear( CompCode, [Options] )
Performance Rated:A++

This will get Current financial Year from QuickBooks, Xero or Sage Accounting Software for reporting.

Get Var

Syntax: =CXL.GetCompanyVar( CompCode, [Type], [QueryValue], [Options] )
Performance Rated:A++

Used for debugging. if Type="datajson,datacustsupp_dcsjson,datastock_dsjson" then QueryValue="ID"

Parameters:

Parameter Description
Options Optional
“” or beginning with “A” gives by Financial Accounting Period
beginning with “AQ” Financial Accounting Period Quarter
beginning with “CQ” Calendar Period Quarter
beginning with “C” gives by Calendar Month
beginning with “W” gives by Calendar Week (Week 1 starting first Monday in year)

Combine Company List

Syntax: =CXL.CombineOptions( OptionsParmList )
Performance Rated:A++

Given a range of cells this will combine the Company Code values into comma seperated list.

   For a tutorial on this function, click here

Parameters:

Parameter Description
OptionsParmList Multiple cell referances to combine E.g. (A2,C2,F2)