Access GDEL Power Bi reports

 

Open Export Report (V 5.0.0)

Filter By Date and or Store

Click into the body of the report (Note Amount)

Click into the 3 dots (ellipsis) to acitvate tool bar

Export Data

Data with current layout

 

This downloads the export as an XLS file into your downloads folder

Open XLS and Remove Footer, make sure Line Sequence is in order and then save as CSV then you can move to the Sage step

Import GL into Sage Intacct 

 

• Log into Sage Intacct
• General Ledger /Journal Entries
• 
• Click Import Transactions
• Click Choose File 
• Then Import button
• You will get a confirmation email that it was succuessful
• If it failures correct the issue in Excel or Notepad and redo the export