Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

Does all accounting software provide same data format on Balace Sheet Table ?

‌Hi All

i am aware of for sales order table in any accounting software it is base on same format , mean sales amount is log by date . So in compute the sales by month table , dimension using month and expression = sum(sales).

i Notice that when get data from GL Table , to compute sales from GL table also similar approach .

When come to Balance sheet analysis using GL table , I do notice in order to compute the Account receivable or current asset like stock , it base on accounting period one opening balance and accounting period 2 closing balance to compute the open balance for period 3.

WWhich is a lot of different from sales order table.

now my question is , does all accounting software also create the raw data table using the same format ?

HOpe those expert have deal with GL table before share with me your insight pls .

PAul

0 Replies