Go Back   English Forum Switzerland > Help & tips > Finance/banking/taxation  
Reply
 
Thread Tools Display Modes
  #1  
Old 04.06.2021, 09:24
Senior Member
 
Join Date: Jun 2014
Location: Zürich
Posts: 286
Groaned at 2 Times in 2 Posts
Thanked 423 Times in 175 Posts
jazh has a reputation beyond reputejazh has a reputation beyond reputejazh has a reputation beyond reputejazh has a reputation beyond repute
How to create the new QR Bills

I have a small business and send somewhat more than 20 bills per month and I would like to switch to (or at least know how to switch to) the new QR-Code bill.

Has anyone done this? If so... here are a few questions I have:
  1. Are you using software from your bank or from another party?
  2. How much does the software cost?
  3. Do you pay per bill or did you buy the software?
  4. Is the software web-based on stored on your computer?
  5. Can the QR bills be automatically generated from an excel list?
I found this site online. Has anyone used it? Can I trust them? I think my bank can also has some software.

Thanks for the help.
Reply With Quote
  #2  
Old 04.06.2021, 10:11
newtoswitz's Avatar
Forum Legend
 
Join Date: Jan 2010
Location: Rapperswil
Posts: 3,754
Groaned at 75 Times in 70 Posts
Thanked 4,537 Times in 2,076 Posts
newtoswitz has a reputation beyond reputenewtoswitz has a reputation beyond reputenewtoswitz has a reputation beyond reputenewtoswitz has a reputation beyond reputenewtoswitz has a reputation beyond reputenewtoswitz has a reputation beyond repute
Re: How to create the new QR Bills

The site looks genuine, but pasting customer details into the online version would still be dubious from a data protection viewpoint.

But I would be comfortable using his installed app version.
Reply With Quote
This user would like to thank newtoswitz for this useful post:
This user groans at newtoswitz for this post:
  #3  
Old 04.06.2021, 10:29
AbFab's Avatar
Forum Legend
 
Join Date: Sep 2006
Location: Zürich
Posts: 8,659
Groaned at 383 Times in 263 Posts
Thanked 13,032 Times in 4,457 Posts
AbFab has a reputation beyond reputeAbFab has a reputation beyond reputeAbFab has a reputation beyond reputeAbFab has a reputation beyond reputeAbFab has a reputation beyond reputeAbFab has a reputation beyond repute
Re: How to create the new QR Bills

Can't your bank supply these??
Reply With Quote
  #4  
Old 04.06.2021, 11:06
Junior Member
 
Join Date: Oct 2011
Location: Lausanne
Posts: 74
Groaned at 0 Times in 0 Posts
Thanked 45 Times in 24 Posts
ne6ef has earned some respectne6ef has earned some respect
Re: How to create the new QR Bills

Here is the QR portal used by UBS clients: https://www.qrportal.ch/
Reply With Quote
This user would like to thank ne6ef for this useful post:
  #5  
Old 05.06.2021, 13:23
Junior Member
 
Join Date: Aug 2006
Location: ztown
Posts: 44
Groaned at 0 Times in 0 Posts
Thanked 15 Times in 9 Posts
chcheese has made some interesting contributions
Re: How to create the new QR Bills

PostFinance offers a solution where you can enter your billing data for around 20CHF/month. Their test platform accepts data from an Excel spreadsheet.

I'm a hobby programmer with requirements similar to yours. I played around with this a few months ago, looking for open source solutions

https://start.duckduckgo.com/lite/?q...ub.com+qr+bill

and settled on

https://github.com/claudep/swiss-qr-bill

which is written in Python. I tested it by printing a QrBill, paying it through my bank's website, and receiving the CAMT054 data. Worked fine.

I'm currently exploring using the Python pyFPDF package with swiss-qr-bill to generate single page invoices as a PDF document. The top part of the invoice is human readable, and the bottom is the QrBill. Everything would be run from a PC, or, in my case, a Raspberry Pi. The plan is to print the PDF, stuff each page in an envelope, and then wait for CAMT054 messages.

Python has open source packages that can read an Excel spreadsheet (or you could export/SaveAs your Excel data to a CSV text file, and feed that to a Python program).

I hope my reply helps and didn't make this more confusing!
Reply With Quote
The following 3 users would like to thank chcheese for this useful post:
  #6  
Old 08.06.2021, 11:52
Senior Member
 
Join Date: Jun 2014
Location: Zürich
Posts: 286
Groaned at 2 Times in 2 Posts
Thanked 423 Times in 175 Posts
jazh has a reputation beyond reputejazh has a reputation beyond reputejazh has a reputation beyond reputejazh has a reputation beyond repute
Re: How to create the new QR Bills

Quote:
View Post
I hope my reply helps and didn't make this more confusing!
Thanks a lot. I am not doing much more than a bit of excel macros, but I'd like to teach myself python in the future. Your response motivates me a bit more.
Reply With Quote
Reply

Tags
qr-rechnung




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to create a web-site??? cricketer Business & entrepreneur 83 07.05.2014 10:43
create a homepage Simon Slider TV/internet/telephone 3 22.06.2013 22:33
Can't create an Event Slaphead Forum support 5 03.08.2011 18:56
How to create a thread? anryan Forum support 2 05.06.2009 17:51


All times are GMT +2. The time now is 15:10.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2022, Jelsoft Enterprises Ltd.
LinkBacks Enabled by vBSEO 3.1.0