Exporting banking Summary to Excel

  • 1
  • Problem
  • Updated 4 months ago
  • Solved
At request of our bookkeeper we are going to start exporting our banking summary to an excel file however there seems to be a glitch on the export that doesn't bring across the medicare/dva description in line 6 but does bring across the correct amount as per below screenshot.

Also is there anyway of having a description of the parameters used to generate the report like there is on the PDF eg Date range, location?


Photo of Adam Woolacott

Adam Woolacott

  • 61 Posts
  • 13 Reply Likes

Posted 1 year ago

  • 1
Photo of Timothy

Timothy, Business Care Manager

  • 880 Posts
  • 266 Reply Likes
Hi Adam. Thank you for bringing this to our attention. We will look at addressing this in a future Front Desk upgrade. 

Regarding including date ranges and location information in the export, it is not typical for this type of information to be included in any export from Front Desk. As quick solution, perhaps you could include this information in the file name when creating the export?
Photo of Adam Woolacott

Adam Woolacott

  • 61 Posts
  • 13 Reply Likes
Thanks Tim for your quick response - we will include it in the file name for the time being.
Photo of Timothy

Timothy, Business Care Manager

  • 880 Posts
  • 266 Reply Likes
Hi Adam. This issue has been resolved in Front Desk v18.1.5. Software upgrades are available to download at www.smartsoft.com.au/support 
Photo of Adam Woolacott

Adam Woolacott

  • 61 Posts
  • 13 Reply Likes
Thanks Tim, thats great
Photo of Adam Woolacott

Adam Woolacott

  • 61 Posts
  • 13 Reply Likes
Hi Tim,
One other thing we noticed is how this excel report handles group deposits. It puts it as an extra category as group deposit rather than splitting the amount into the existing direct deposit or cheque lines.

We have to manually then split this up for our banking to make sense. Are we able to get this automated?

Thanks,

Adam
Photo of Timothy

Timothy, Business Care Manager

  • 879 Posts
  • 266 Reply Likes
Hi Adam. This change has been implemented in Front Desk v18.3.4 which is available to download at www.smartsoft.com.au/support
Photo of Gerry

Gerry, Senior Application Developer

  • 123 Posts
  • 29 Reply Likes
Hi Adam. I'm not 100% sure what you mean here. Currently, the banking summary export includes separate lines for direct deposit, group deposit, cheque, and group cheque. Which lines do you have to manually split?

If you know our helpdesk email address you can email us with some examples (I haven't included our email address here as we'll get spammed), or open a support case at www.smartsoft.com.au/support and we will be able to help you out.
Photo of Adam Woolacott

Adam Woolacott

  • 61 Posts
  • 13 Reply Likes
Thanks Gerry. We have to add the group deposit amounts to the separate direct debit amount manually on the excel export to get the total direct debit amount for that days banking. I am unclear why group direct deposits is listed separate to other direct deposits?
Photo of Gerry

Gerry, Senior Application Developer

  • 123 Posts
  • 29 Reply Likes
Hi Adam. I've looked into it, and on the report itself we do consolidate these values into a single amount, whereas the export doesn't. I guess at the time we thought that providing more information in the export would be useful, but I agree that the behaviour of the export should be the same as the report. We will make the change you have requested. Thank you for providing this feedback.
Photo of Kelly Vaughan

Kelly Vaughan

  • 9 Posts
  • 0 Reply Likes

Could you also please consider in a future upgrade, when exporting the info to excel, is there a way that it would be able to breakdown into GST and GST FREE for each payment type?