News
At the request of customers we implemented transformation of the statements with cash on delivery payments Packeta (Zasilkovna).
BIATEC.CZ now allows you to transform the statements of the GP Webpay payment gateway to ABO / GPC / CSV / SEPA XML.
We have completed the migration of BIATEC.cz for a more stable server environment. We believe you will appreciate it as clients. We have upgraded several software modules. Please continue to send any smallest ideas to info@biatec.cz. Thank you for your loyalty.
Since 11 January 2023 we are not registered to VAT.
Biatec.cz now allows you to transform WISE statements into ABO / GPC / CSV / SEPA XML.
Biatec.cz now allows you to transform cash on delivery payments for your shipments sent via GLS to ABO / GPC / CSV / SEPA XML.
We added transformation for the GoPay [CSV format] statements into GPC, or Sepa XML. Transformed statement (GPC, Sepa XML) you can import into your accounting software, so as standard bank statement.
We added transformation for the Zasilkovna statements into GPC, or Sepa XML. Transformed statement (GPC, Sepa XML) you can import into your accounting software, so as standard bank statement.
We added states transformation for the GLS company into GPC, or Sepa XML. Transformed statement (GPC, Sepa XML) you can import into your accounting software, so as standard bank statement.
Now You can transform Stripe statements into GPC, or Sepa XML. Transformed statement (GPC, Sepa XML) you can import into your accounting software, so as standard bank statement.
Now You can clean / transform variable symbol in your statements. You can set the transformation in the settings of your account.
Now You can transform Braintree statements into GPC, or Sepa XML. Transformed statement (GPC, Sepa XML) you can import into your accounting software, so as standard bank statement.
Now You can transform TrustPay statements into GPC, or Sepa XML. Transformed statement (GPC, Sepa XML) you can import into your accounting software, so as standard bank statement.
Now You can transform Ulozenka statements into GPC, or Sepa XML. Transformed statement (GPC, Sepa XML) you can import into your accounting software, so as standard bank statement.
Now You can transform FOFR statements into GPC, or Sepa XML. Transformed statement (GPC, Sepa XML) you can import into your accounting software, so as standard bank statement.
Do You use George account by Ceska sporitelna bank? Now You can transform these statements into GPC, or Sepa XML. Transformed statement (GPC, Sepa XML) you can import into your accounting software, so as standard bank statement.
Now You can transform AiBank statements into GPC, or Sepa XML. Transformed statement (GPC, Sepa XML) you can import into your accounting software, so as standard bank statement.
Biatec is now ready to find variable symbol in an export from Fakturoid and to include them into PayPal transaction. Output is the PayPal transformed statement in the format of GPC / Sepa XML, which contains variable symbols. During the import into your accounting software, the transactions are matched with issued invoices.
Do You use Bluesnap payment gateway? Now You can transform these statements into GPC, or Sepa XML. Transformed statement (GPC, Sepa XML) you can import into your accounting software, so as standard bank statement.
Do You sell on Amazon? Now You can transform these statements into GPC, or Sepa XML. Transformed statement (GPC, Sepa XML) you can import into your accounting software, so as standard bank statement.
Do You use Revolut payment gateway? Now You can transform these statements into GPC, or Sepa XML. Transformed statement (GPC, Sepa XML) you can import into your accounting software, so as standard bank statement.
Do You use Adyen payment gateway? Now You can transform these statements into GPC, or Sepa XML. Transformed statement (GPC, Sepa XML) you can import into your accounting software, so as standard bank statement.
Do You use GoPay payment gateway? Now You can transform these statements into GPC, or Sepa XML. Transformed statement (GPC, Sepa XML) you can import into your accounting software, so as standard bank statement.
We support transformation of the Raiffeisenbank statement in CSV format! Check the
instructions.
Do You use ComGate payment gateway? Now You can transform these statements into GPC, or Sepa XML.
Do you have a signed contract with czech DPD? Make it easier to send via DPD! Set up parameters via My Account -> DPD Settings (parameters you get from DPD). From now, you can use our DPD delivery service. Create a csv
base on our example with a list of shipments using standard transformation formular. The output is 4 files: CSV file with tracking codes, PDF file with shipping labels, PDF file with manifest, and control CSV file in which you will find a report on the performed operations.
Do you send shipments using the Czech DPD? Make it easier to work with tracking codes. After importing shipments to mojedpd.cz, transform the manifest file (using our service) to a tracking code file in .csv format. Which You can easily import to MS Excel or Google Tables.
Original PayPal statement differs. Do You have variable symbol in the column "Invoice Number", or "Item ID"? Default setup is "Invoice Number". You can change it in My account > Transformation setup > The variable symbol column (PayPal statement) > Invoice Number / Item ID
If You use Google Account to sign up in to Your account and You decide to use login and password, now You can. You can set Your password in My account > Account setup.
Original PayPal statement differs. Do You have variable symbol in the column "Invoice Number", "Item ID", "Custom No"? Default setup is "Invoice Number". You can change it in My account > Transformation setup > The variable symbol column (PayPal statement) > Invoice Number / Item ID / Custom No
Statement of the Raiffeisenbank for Credit Card Transactions is now supported. Please choose PDF as original file.
Statement of the Ceska Sporitelna Bank is now supported. In the internetbanking choose: CSV - values divided by comma (;).
Note: In case, You choose time interval (e.g. 60 days), during the transformation You will be asked for account number.
We updated offered transactions packages.
1) The dash between prefix and account number could lead to transformation failure. We covered this issue and since today the dash between prefix and account number is supported.
2) In case, the incommming transaction on the PayPal account runs currency conversion, we will include the exchange rate into note of the transaction in the XML file. Unfortunately it is impossible to add this exchange rate to ABO/GPC file, as the format doesn't support it.
In case, You buy transformation credit and You pay using PayPal, system will generate invoice for You with testing FIK. From 1.3.2017 we will process EET in production mode include reall FIK.
If You ever wanted to transform more statements without uploading each separately, now You can. Put all files into one ZIP file (statements from PayPal, can be together with statements from Raiffeisenbank). Then choose "Upload statement" and than "d) Batch processing". The ZIP file will be uploaded and the files transformed separately on the server. It can take about 5 minutes, until You will see them between another statements.
Note: Batch processing works correctly, in case no account number entering is necessery.
For few clients PayPal changed the ordering of the transactions from descendent (oldest transaction in the last row) to ascendent (newest transaction in the last row). Since 14.11.2016 will be well processed also these statements.
Import-statement.eu uses protected connection using https.
SEPA XML format change: before change:
<RmtInf><Ustrd>Payment from sasalicen@gmail.com</Ustrd></RmtInf>
<AddtlTxInf>Payment from sasalicen@gmail.com</AddtlTxInf>
after change:
<RmtInf><Ustrd>Payment from sasalicen@gmail.com for transaction: 123456</Ustrd></RmtInf>
<AddtlTxInf>Payment from sasalicen@gmail.com for transaction: 123456</AddtlTxInf>
Czech SEPA XML format support
In addition to Slovak bank association format, we support SEPA XML from Czech bank association. Please set expected format in My account > Transformation setup > SEPA XML format > SBA (Slovak bank association) / CBA (Czech bank association). Because of SEPA XML support by accounting software in Slovakia is stronger, the default value is SBA. Accounting sw support by Czech accounting sw is insufficient yet.
Temporary hold in PayPal statements
PayPal sometimes holds accepted payments. In the statement is described as "temporary hold" (when holded). In SEPA XML we will add to such a transaction note with Transaction ID:
<RmtInf><Ustrd>Payment temporary hold by PayPal: 74T21733AA5305003</Ustrd></RmtInf>
<AddtlTxInf>Payment temporary hold by PayPal: 74T21733AA5305003</AddtlTxInf>
Temporary hold released in PayPal statements
PayPal sometimes holds accepted payments. After 20-30 days releases them. In the statement described as "temporary hold" + "released" (when released). In SEPA XML we will add to such a transaction note with Transaction ID:
<RmtInf><Ustrd>Payment temporary hold by PayPal released: 7N126325BP302440V</Ustrd></RmtInf>
<AddtlTxInf>Payment temporary hold by PayPal released: 7N126325BP302440V</AddtlTxInf>
PayPal fees and variable symbol
Fees in SEPA XML file do not include variable symbol anymore, so the accounting software will not paire the fee with invoice.
Original PayPal statement differs. Do You have variable symbol in the column "Invoice Number", or "Item ID"? Default setup is "Invoice Number". You can change it in My account > Transformation setup > The variable symbol column (PayPal statement) > Invoice Number / Item ID