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

Open "Training 1 - GL Granular Functions" on YouTube from 1:45

To see a demo of this function =CXL.GetCompanyName() in action, click this link.

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++

Open "Training 1 - GL Granular Functions" on YouTube from 2:40

To see a demo of this function =CXL.GetCompanyStatus() in action, click this link.

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)