bayanSheet

bayanSheet is a web app for customs-clearing companies in Oman. You upload a customs declaration (a bayan) and check its values. bayanSheet then adds a row to your company's Google Sheet and files the document in your company's Google Drive.

What bayanSheet does

  • Reads a bayan PDF on your device and shows you its values to check.
  • Adds one row per bayan to your company's Google Sheet, and files the document in your Google Drive.
  • Checks each declaration with Oman Customs, and can put the final copy in its document once Customs finishes it.
  • Matches cargo invoices and customer invoices to their shipments, and can create customer invoices in QuickBooks Online (optional).

How bayanSheet uses your Google data

Signing in with Google

If you sign in with Google, bayanSheet gets your name, email address and profile picture from Google to create your account and sign you in.

Google Drive and Google Sheets

bayanSheet asks for one Google Drive permission, drive.file. With it, bayanSheet can open only the files you pick in Google's file picker and the files it creates for you: your company's sheet, the documents it files and the invoice copies.

Gmail: cargo invoices (optional)

An owner can connect your company's Gmail. To find cargo invoices, bayanSheet then uses gmail.readonly and reads only the emails that match a search your company saves. It copies each PDF invoice into your Google Drive and matches it to its shipment. It never deletes, labels or marks mail as read. If you also use QuickBooks, a matched invoice's total can fill a line on a QuickBooks invoice that a person creates and confirms.

Gmail: Send to client (optional)

Where we have turned on Send to client for your company, bayanSheet uses gmail.send to email a QuickBooks invoice to your client from your company's Gmail. Where attaching the shipment's document is on, that email can also carry that document from your company's Drive, with any cargo invoices from your mail that were merged into it. An email goes only when a person presses Send email, never on a schedule. If Gmail does not say whether an email went out, bayanSheet looks for that one email in your Sent folder.

An owner can disconnect Gmail at any time in Settings › Gmail, or pause syncing there.

How to pause, disconnect or delete your Gmail data

We do not sell Gmail data, use it for ads, or use it to develop, improve, or train AI or machine-learning models.

bayanSheet's use of information received from Google APIs will adhere to Google API Services User Data Policy, including the Limited Use requirements.