Page 2 of 3 FirstFirst 123 LastLast
Results 11 to 20 of 25

Thread: Processing Yoco Card Transactions in Pastel

  1. #11
    Full Member
    Join Date
    Jul 2019
    Location
    Pretoria
    Posts
    71
    Thanks
    8
    Thanked 9 Times in 9 Posts
    Thanks Andromeda

    You are so right, it is not a quantum leap forward. For me it is important to see the entire transaction and to then setup your structure and Pastel in such a way that it reflects it.

    I have gone further and also made the following illustration of the transaction as it happens.

    Attachment 7636

    I really appreciate us all having this conversation as I do believe YOCO is a fast and inexpensive solution for SME's. But the standard Pastel processing method is not fast and cost efficient, so we need to see how we can set processes in place to make it quick to capture in Pastel.
    Alec Candiotes (CA) SA
    Business Intelligence and Report Automation developer

    www.mybi.co.zaalec@mybi.co.za • 072 997 9553

  2. #12
    Full Member
    Join Date
    Jul 2019
    Location
    Pretoria
    Posts
    71
    Thanks
    8
    Thanked 9 Times in 9 Posts
    Hi Guys.

    I sat with my team and we created a 3 step procedure how we think you can capture YOCO transactions in Pastel quickly. I loaded the video on a LinkedIn post here:

    https://www.linkedin.com/posts/alec-...943645184-hst4

    I am sorry for not posting the video here, but I am not able to upload a video in this post.

    Would love to hear your opinion on it.

    Kindest regards,
    Alec
    Alec Candiotes (CA) SA
    Business Intelligence and Report Automation developer

    www.mybi.co.zaalec@mybi.co.za • 072 997 9553

  3. #13
    Full Member
    Join Date
    Jul 2019
    Location
    Pretoria
    Posts
    71
    Thanks
    8
    Thanked 9 Times in 9 Posts
    Hi HJVW

    The fee calculation as far as I can see from their website is 2.95% x 1.15 of the total cash paid.

    It unfortunately is not always an exact science as different ERP systems have different decimals after the zero.

    Hope this helps.

    All the best.

    Alec Candiotes
    Alec Candiotes (CA) SA
    Business Intelligence and Report Automation developer

    www.mybi.co.zaalec@mybi.co.za • 072 997 9553

  4. #14
    Junior Member
    Join Date
    May 2019
    Location
    Johannesburg
    Posts
    22
    Thanks
    8
    Thanked 0 Times in 0 Posts
    Hi Guys,

    Thank you for all of your responses.

    Unfortunately I cannot properly see the video you posted Alec, however I really appreciate your guys' input on this. The way I'm currently capturing this is extremely confusing and tedious. There MUST be an easier way!

    I'm using Pastel Accounting Xpress V17, and here's what I ended up doing:

    As YOCO sends me an invoice at the end of every month for all of the fees deducted, I ended up creating a supplier account for YOCO.

    When capturing my bank statements, I allocate every YOCO settlement to the respective customer account, using the FULL AMOUNT invoiced to the customer. For instance: If the settlement amount is R2415.19, and the original amount swiped was R2500.00, I capture R2500.00. This way, the customer account balances to R0.00.

    Then, using the same reference number (still on the receipts side), I capture the YOCO fee as a negative right below it (-R84.81), allocating it to the relevant expense account. (This also means I constantly need to reference back to the online portal or mobile app, to confirm the fee amount for each specific settlement/transaction).

    Ultimately, the transaction reflects as a consolidated entry of R2415.19 (R2500.00 - R84.81) in my cash book, which corresponds with my bank statement. At the same time, the supplier account is debited with R84.81. When capturing the YOCO invoice at the end of the month, I allocate all the relevant fees to this invoice, which also enables me to cross check and ensure every transaction & fee is accounted for, as the total fees should = the total of the invoice.

    This was the only way I could be sure that VAT would be accounted for in the correct way. What are your thoughts on this?

  5. #15
    Silver Member
    Join Date
    Aug 2018
    Location
    Johannesburg
    Posts
    262
    Thanks
    0
    Thanked 35 Times in 31 Posts
    Hi Ola

    Have you considered creating a separate cashbook to record the YOCO entries in? Receipt the full R2500 from the customer into YOCO receipts. Then use the cashbook transfer wizard and do a cashbook transfer to the current account from YOCO receipts for the value less the fees. Raise the supplier invoice from YOCO as a 1 line entry to bank charges including VAT at month end. "Pay" the YOCO supplier at month end from the YOCO cashbook. The balance in the YOCO cashbook will be equal to the value on their invoice, if all entries were captured correctly. You will have a separate cashbook to trace all the YOCO entries in and can do a bank recon on their transactions, and your current account won't have all the consolidated entries to work through during the recon process.

    It doesn't really decrease the processing required, but might make reconciling the account easier.

  6. #16
    Full Member
    Join Date
    Jul 2019
    Location
    Pretoria
    Posts
    71
    Thanks
    8
    Thanked 9 Times in 9 Posts
    Hello Ola

    My apologies that the link was not working and for talking long to respond to you.

    Our MyBI team has been setting up a Youtube channel to load the video we created so that I can send you the url to the video. Here it is:

    .

    Let me know what your thoughts are. I look forward to hearing from you.

    All the best,
    Alec
    Alec Candiotes (CA) SA
    Business Intelligence and Report Automation developer

    www.mybi.co.zaalec@mybi.co.za • 072 997 9553

  7. #17
    New Member
    Join Date
    Oct 2019
    Location
    Durbanville
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I use Sage and am not a bookkeeper, so this is probably not very professional but it’s what I do for our sports club bar sales.
    Created a “Liquor sales” customer and “Yoco charges” in expense accounts.
    Create invoices from the sales report on Yoco portal (all items are listed in “Products”)
    Great help with stock control.
    Allocate the cash received to the invoice.
    When the Yoco payment is imported via bank refresh, I click on the “split” and allocate.
    Liquor sales 1,296.00 (change from R1,252.05)
    Yoco charges -R43.95

  8. #18
    Full Member
    Join Date
    Jul 2019
    Location
    Pretoria
    Posts
    71
    Thanks
    8
    Thanked 9 Times in 9 Posts
    Hello Keith.

    You may not be a bookkeeper, but you just absolutely blew my mind!! This is a feature in bank manager I never knew about. Thank you for showing me. Below is a screen print of this option (just right click on any line and you will see it).
    Click image for larger version. 

Name:	Split transaction in Bank manager.jpg 
Views:	191 
Size:	18.9 KB 
ID:	7691

    This option seems manageable in a low transaction environment. But how do you manage and reconcile it if you have say 50 YOCO sales a day? Or are you capturing your individual sales through a POS / cash register and then bringing in 1 sale a day into Pastel?

    My second question is how do you know your Liquor sales amounted to a gross amount of R1,296 when processing in bank manager? Do you see this in the debtors view balances, write it down and then go and do the transaction in bank manager?

    Thanks again for sharing Keith. Neat feature!

    Looking forward to hearing from you.

    All the best!
    Alec Candiotes (CA) SA
    Business Intelligence and Report Automation developer

    www.mybi.co.zaalec@mybi.co.za • 072 997 9553

  9. #19
    New Member
    Join Date
    Oct 2019
    Location
    Durbanville
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi Alec
    Both your presumptions are correct.
    Invoicing is actually quite simple, one may stock of 100 products but sales for the day may only be for various amount of 20 products which is all listed in Yoco’s portal.
    I have 2 monitors, one with Sage open and the other with the Yoco portal open.

    Click image for larger version. 

Name:	yocosample.jpg 
Views:	205 
Size:	21.9 KB 
ID:	7692

  10. #20
    New Member
    Join Date
    Oct 2019
    Location
    Durbanville
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Yoco sales report
    Click image for larger version. 

Name:	yocos.jpg 
Views:	333 
Size:	20.6 KB 
ID:	7693

Page 2 of 3 FirstFirst 123 LastLast

Similar Threads

  1. pasting transactions in pastel version 11
    By law muyambo in forum Accounting Forum
    Replies: 0
    Last Post: 10-Oct-18, 04:10 PM
  2. [Question] Pastel 12 importing transactions posted in another Company
    By nyarai in forum Accounting Forum
    Replies: 0
    Last Post: 05-May-16, 12:48 PM
  3. World Currency Card vs standard cheque card for overseas transactions
    By videosurfer in forum General Business Forum
    Replies: 0
    Last Post: 21-Nov-14, 10:13 AM
  4. [Question] Processing 'out of period' transactions
    By Jacky in forum Accounting Forum
    Replies: 2
    Last Post: 03-Feb-14, 07:54 PM
  5. Quickbooks Credit Card Transactions
    By MadJan in forum Accounting Forum
    Replies: 1
    Last Post: 21-Jul-11, 11:24 AM

Tags for this Thread

Did you like this article? Share it with your favourite social network.

Did you like this article? Share it with your favourite social network.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •