Home

Importing data into a simple general ledger

Mike Gregory
Regular Visitor

Hello, 

 

I think that this will be a fairly simple question. 

 

I want an efficient way to import simple accounting data from staff cash reconciliation worksheets into an even more simple general ledger. 

 

The process would work (in my head any way) like. 

 

Step 1. Staff member saves to SharePoint (we use Office 365 Pro Plus ) an excel file with the details of the their cash reconciliation. Is looks like this.... there would be more data.

 

Image

 

 2. From a different file, the simple general ledger, I would import the data from the reconciliation, adding expenditure line by line. The general ledger  looks like this....

 

Image

 

3. I then can simply analysis the data.

 

I know how to do the analysing part. I just need some pointers on the importing of the data part. 

 

Mike

1 Reply

Hi @Mike Gregory ,

 

That is job for Power Query - you may query your source file and filter all intermediate blank rows and rows with Data and Sub totals. Moreover, if you have in your Sharepoint folder few such files generated by different people you may combine all of them into one using From Folder connector. The only point all files have to have the same structure.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies